Forum Discussion

schau's avatar
schau
Regular Visitor
8 years ago
Solved

Transforming CSV file from SharePoint folder

Hi all,   I have a SharePoint folder which holds a number of large csv files. I want to set up a query which opens all the files in the folder and puts the data into a single view. I was wondering ...
  • schau's avatar
    schau
    8 years ago

    Hey Lydia,

     

    Thanks for the reply. The headers in the CSV are not exactly identical as it also contains some additional metadata. I think because of this, it's not able to automatically detect that they are headers and end up leaving them in the dataset as well.

     

    I've figured it out however. After combining the files, I needed to remove the headers from the pre-generated transfomration sample file to get rid of all the header information.

     

    Thanks

schau's avatar
schau
Regular Visitor
8 years ago

Hey Lydia,

 

Thanks for the reply. The headers in the CSV are not exactly identical as it also contains some additional metadata. I think because of this, it's not able to automatically detect that they are headers and end up leaving them in the dataset as well.

 

I've figured it out however. After combining the files, I needed to remove the headers from the pre-generated transfomration sample file to get rid of all the header information.

 

Thanks

Anonymous's avatar
Anonymous
Not applicable
8 years ago

schau,

Glad to hear that the issue is solved. Please mark appropriate replies as solutions, that way, other community members would easily find the solution when they get same issues.

Regards,
Lydia