Forum Discussion

MrSplinter's avatar
MrSplinter
Frequent Visitor
3 years ago
Solved

Tables for each file in folder, load header names from separate file

I have the following files: - A folder with multiple .CSV-files. Each file might have a different number of columns. The header names are missing. - A .CSV-files in this folder called Index.csv, ...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    3 years ago

    Hi MrSplinter

     

    I'm afraid this step "- Create a table for each separate file" cannot be done with Power Query. Power Query cannot create queries according to file names automatically. Queries need to be created by you manually. So the number of queries is fixed before any refresh. 

     

    The closest result I can achieve with Power Query is like below. I can get the table you want for every file row. However, I'm not able to split this column into multiple queries (tables) automatically as Power Query doesn't support that. I have attached the sample file for your reference. 

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it. Highly appreciate your Kudos!

v-jingzhang's avatar
v-jingzhang
Community Support
3 years ago

Hi MrSplinter

 

I'm afraid this step "- Create a table for each separate file" cannot be done with Power Query. Power Query cannot create queries according to file names automatically. Queries need to be created by you manually. So the number of queries is fixed before any refresh. 

 

The closest result I can achieve with Power Query is like below. I can get the table you want for every file row. However, I'm not able to split this column into multiple queries (tables) automatically as Power Query doesn't support that. I have attached the sample file for your reference. 

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it. Highly appreciate your Kudos!