Combine Txt files

[Anonymous]

Hello,

I need help, I have 3 txt files under one folder. These txt files doesnt have header.

I want to combine them and keep the their file name and folder path each rows. So i know which data source it belongs to. But when i click comine these (Names & Folder Path) columns are not included

Thanks,

Leo

[mahoneypat · Accepted solution]

You can add a custom column in your query with Csv.Document([Content]).  That will add a "Table" in each row that you can expand to combine your data, and keep your file and folder info.

Pat

[Anonymous]

Thanks for the reply. But i tried that , i was able to add the custom column but when i click the combine icon in content, the folder path and name is still not there.