Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

combine tables via crawling a list of files

Hello,

 

I have a list with paths of files e.g., A Query Q1 = {"path1","path2","[path3"} and a I created a function File2Table that gets as an argument a path and returns a table. E.g., File2Table = (path as text) => ......

 

How can I append all tables from each path? E.g., Table.Combine({File2Path(Q1{0}), File2Path(Q1{1}), ...})?

 

Thanks!

1 ACCEPTED SOLUTION
v-chuncz-msft
Community Support
Community Support

@Anonymous,

 

You may use code below.

    result = Table.Combine(List.Transform(Q1, each File2Table(_)))
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-chuncz-msft
Community Support
Community Support

@Anonymous,

 

You may use code below.

    result = Table.Combine(List.Transform(Q1, each File2Table(_)))
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

This is what I have done eventually

Results=List.Generate(()=>0, each _ < List.Count(Q1), each _ +1, each File2Table(Q1{_})),
out=Table.Combine(Results)



but @v-chuncz-msft has a much better and easier to follow solution.

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.