Forum Discussion

ronny_wdk's avatar
ronny_wdk
Frequent Visitor
6 years ago
Solved

extra column in data source

I use a folder as data source. In the folder are multiple .csv files (a file a day).   I recently added a column to the source, so the old files have 50 columns, the new files have 51 columns.   ...
Need Help
  • v-lid-msft's avatar
    v-lid-msft
    6 years ago

    Hi ronny_wdk ,

     

    How about the result after you follow the suggestions mentioned in my original post?Could you please provide more details about it If it doesn't meet your requirement?


    Best regards,

leigh_yh's avatar
leigh_yh
Frequent Visitor
6 years ago

Please help - I am having the same issue. I followed the steps you suggested and my new columns appear but several of the rows do not load correctly. It appears that data from several columns is being combined and shifted  into the first column. For example, the  Project Status column should all contain "Active".

 

Thanks in advance!

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 
 
 
 
v-lid-msft's avatar
v-lid-msft
Community Support
6 years ago

Hi leigh_yh ,

 

It looks like the Line 22 and 24 does not convert into tables correctly, could you please verify if these rows have correct format in the data source? Could you please describe the approximate action steps?


Best regards,