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
It seems the columns are exposed as variables so a simple(r)
column * 100
should do.