Question 90015 in PostgreSQL Question posted in
The official documentation can be found here.

DBeaver CSV Import Transform Expression – Postgresql

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
Tags:

2

Answers


  1. 0

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

    Login or Signup to reply.
  2. 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

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search