Forum Discussion

kana's avatar
kana
Icon for Helper I rankHelper I
6 years ago

How to union dbase files into 1 query and also a custom column

Dear All Master With this I want the UNION database to be 1 query in the power query. I already used union in the connection string but I can't custom the columns for each dbf table. What I want as ...
Need Help
kana's avatar
kana
Icon for Helper I rankHelper I
6 years ago

Dear Sir,

 

I know what you mean by using a formula to create custom columns by analyzing each row. The problem is that it cannot identify every line because there are no markers. Now I am asking if the function of the M language code is to add a custom column based on the folder path.

 

 

Thanks

 

Kana

 

 

artemus's avatar
artemus
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

kana  You can start with Folder.Files("Path to BOJ folder")

From there filter the files for the ones you want, then add a custom column as mentioned.