Forum Discussion
Perform transformations on a table in each row
I have many pdf files within a folder. My first source is Folder.Contents on the folder which results in a column that has tables containing the pdf data.
My problem is that each table needs transposed before it is combined with the other ones. Is there a way I can send every row into a series of steps and then append it to the main table?
My queries are on my GFE so I will do my best to provide explanations, but I cannot get screenshots of my queries or steps.
Thank you in advance,
Kevin
- Anonymous3 years ago
Hi Attrazoine
Maybe you can refer to the following links:
Combine multiple files in Power query editor - Microsoft Power BI Community
Power Query: Combine Files from Multiple Folders - Enterprise DNA
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- AnonymousNot applicable
Hi Attrazoine
Maybe you can refer to the following links:
Combine multiple files in Power query editor - Microsoft Power BI Community
Power Query: Combine Files from Multiple Folders - Enterprise DNA
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- AttrazoineNew Member
Thank you Yolo! That is perfect. I spent an hour trying to Google what I wanted to no avail. This is greatly appreciated.