CODEWITHSUNDEEP
postgresqlcsvdbeaverjexl
AndreaVitali
AndreaVitali

Reputation: 1

DBeaver CSV Import Transform Expression

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

Upvotes: 0

Views: 2272

Answers (3)

João Paulo S Almeida
João Paulo S Almeida

Reputation: 1

You can use the expression

get('Column7') * 100

Upvotes: 0

greg__s
greg__s

Reputation: 1

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

Upvotes: 0

henrib
henrib

Reputation: 364

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

Upvotes: 1

Related Questions