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,

My point is successfully using the script in sql statement to merge the dbase file into 1 query, the problem is I want a custom column. So I ask you whether you can custom column based on the folder path with the M language function code language?

 

Rgrds

 

Kana

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

Dear Sir,

 

 

Please give me solution.

 

Thanks

kana