Power query Combine workbook by selecting worksheet name

[12Rev79]

Dear Expert,

Sorry to bother you, I try searching in the internet and tutorials but no luck.
I have a number of Workbook in my folder "01 prodn" I want to combine workbook with the sheetname like "WeldingReport", "Welding", "WeldingProduction"

Please any help.

Thanks in advance.
12Rev79

 

[alex78]

Hi,
Try

= Table.Combine(List.Transform(Folder.Files("C:\PQ")[Content], each Table.Combine(Table.SelectRows(Excel.Workbook(_,true), each [Kind] = "Sheet" and Text.Contains([Item], "Welding"))[Data])))

Regards,

 

[12Rev79]

Hi,
Try

= Table.Combine(List.Transform(Folder.Files("C:\PQ")[Content], each Table.Combine(Table.SelectRows(Excel.Workbook(_,true), each [Kind] = "Sheet" and Text.Contains([Item], "Welding"))[Data])))

Regards,

Thanks so much Alex78, this is exactly I am looking for. Thanks again