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 ste...
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!!!

     

smpa01's avatar
smpa01
Community Champion
5 years ago

pab11can you paste the query here please

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

 

  • smpa01's avatar
    smpa01
    Community Champion
    5 years ago

    pab11 

    • pab11's avatar
      pab11
      Helper I
      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!!!

       

      • smpa01's avatar
        smpa01
        Community Champion
        5 years ago

        pab11yes !!!