Load additional column from csv file

[pab11]

Hello everyone,

currently i am loading a table with 10 columns from csv-file into my database.

Now i want to add another column (the previous 10 column names stay the same), but in the first step "source" the new 11th column doesn't show up.

How can i add this new column?????

Thank you so much in advance!

regards

P.

[smpa01]

@pab11can you paste the query here please

[pab11]

@smpa01

Actually it was this simple csv conncetion with path, delimiter, data type etc.:

But i guess you mean something different...where can i find the query?

Thanks!

pab11

[smpa01]

@pab11 

[pab11 · Accepted solution]

Ahaaaa! I changed columns to 11 and now it works!

I think that's what you were up to right?

Thank you!!!

[smpa01]

@pab11yes !!!