DBeaver CSV Import Transform Expression

1.3k Views Asked by At

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

There are 2 best solutions below

0
On

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

0
On

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