Mar 21 2018
07:18 AM
- last edited on
Jul 12 2019
11:05 AM
by
TechCommunityAP
Mar 21 2018
07:18 AM
- last edited on
Jul 12 2019
11:05 AM
by
TechCommunityAP
Hi Masters!
Can anyone please help me out of here? I also attached the file for simulation and reference.
Mar 21 2018 07:55 AM
SolutionHi Ovette,
You shall add the function which picks up the content of each file, add what it returns as a column to your query and expand resulting table.
Please see attached.
Mar 21 2018 07:58 AM
Forgot to say, connector to the folder do the same automatically - attached
Mar 21 2018 08:25 AM
Mar 21 2018 08:26 AM
Mar 21 2018 08:54 AM
Thank you for the idea, I was able to create that function and I am rolling now...
Big THANKS!!!
Oct 04 2019 07:21 PM
Can you can you explain what you did in detail for me please? Im a bit of a beginner. I’m having the same error that you did in your first post. I’m wanting a dynamic query folder path. When I click on double expand arrows I get the cannot find table name table2 error.
Im using power query (should have same solution as power bi though).
May 07 2021 05:42 AM
Jun 25 2021 08:42 AM
@GohLazar Yes, this is much easier than the route I took before.
Mar 21 2018 07:55 AM
SolutionHi Ovette,
You shall add the function which picks up the content of each file, add what it returns as a column to your query and expand resulting table.
Please see attached.