Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
pab11
Helper I
Helper I

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.

pab11_0-1612283078844.png

 

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

 

Thank you so much in advance!

regards

P.

1 ACCEPTED SOLUTION

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

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

pab11_0-1612284823759.png

 

Thank you!!!

 

View solution in original post

5 REPLIES 5
smpa01
Super User
Super User

@pab11can you paste the query here please

Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
My custom visualization projects
Plotting Live Sound: Viz1
Beautiful News:Viz1, Viz2, Viz3
Visual Capitalist: Working Hrs

@smpa01

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

pab11_0-1612284280311.png

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

 

Thanks!

pab11

 

Capture.PNG

@pab11 

Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
My custom visualization projects
Plotting Live Sound: Viz1
Beautiful News:Viz1, Viz2, Viz3
Visual Capitalist: Working Hrs

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

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

pab11_0-1612284823759.png

 

Thank you!!!

 

@pab11yes !!!

Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
My custom visualization projects
Plotting Live Sound: Viz1
Beautiful News:Viz1, Viz2, Viz3
Visual Capitalist: Working Hrs

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors