Forum Discussion

pab11's avatar
pab11
Helper I
5 years ago
Solved

Load additional column from csv file

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.

Need Help
  • pab11's avatar
    pab11
    5 years ago

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

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

     

    Thank you!!!

     

5 Replies

    • pab11's avatar
      pab11
      Helper I
      5 years ago

      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