0

I'm trying to import a CSV into an existing PostgreSQL table using DBeaver Import Tool and I need to transform a numeric value multiplying it by 100.
Someone knows the syntax to be used in the expression?
The official documentation talks about JEXL expressions, but i can't find any example.

I can't post images, but the one in this question is exactly where i need to put the expression.

I was expecting something like:

${column}*100

2 Answers2

1

It seems the columns are exposed as variables so a simple(r) column * 100 should do.

henrib
  • 187
  • 6
0

I found that when importing data from a CSV file, it was necessary to name the column variable exactly as it was listed in the 'Tables mapping' pane of the Data Transfer task editor, for example Column7 * 100

greg__s
  • 1
  • 1