Forum Discussion
Solved
Row filtration while expanding table
Hi Community, I have a requirement where I have to pull files from the folder and combine all the files into Source. There are contents of previous file in each file. For instance, If I have data ...
1, combine all the data without any filters and keep the filenames
2, add a new step with this code
=Table.Combine(Table.Group(Source,"date",{"n",each List.Last(Table.Group(_,"filename",{"t",each _})[t])})[n])
1, combine all the data without any filters and keep the filenames
2, add a new step with this code
=Table.Combine(Table.Group(Source,"date",{"n",each List.Last(Table.Group(_,"filename",{"t",each _})[t])})[n])
Hi wdx223_Daniel
I have Tried this and this works perfectly. Thanks
Regards
Fazil M