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
edhans's avatar
edhans
Icon for Community Champion rankCommunity Champion
6 years ago

kana I'm not clear on your question. Can you post a screenshot of what the above code shows on your computer, and what your expected output is? I cannot test the code because I don't have dBase files nor the dBase ODBC driver. 

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

Dear Sir,

As per your request I attached a screenshot of mine

From the code that I tried successfully, is it possible if I custom a column based on the path of the folder with the Code M language.

Thanks

 

Kana

 

 

 

  • edhans's avatar
    edhans
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Sorry, I am not clear exactly what "From the code that I tried successfully, is it possible if I custom a column based on the path of the folder with the Code M language." means.

  • 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