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
let
    Source = Odbc.Query("dsn=dBASE Files", "Select * From C:\Test\mytest\m18\IFG.DBF Union Select * From C:\Test\mytest\boj\IFG.DBF Union Select * From C:\Test\mytest\md2\IFG.DBF#(lf)"")")
in
    Source

Dear Sir,

Ok please help me to custom the connector.

The code that I use in the connection string can be just that I don't add custom columns in each dbf table.

 

Thanks

 

Kana

 

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

    Dear Sir,

     

    Please guide me if using a custom connector and how to if via ACCDB

     

    Thanks

     

    Kana

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

      Dear sir,

       

      I have a solution, Can you help if the custom column that I want is based on the folder path. So please help me in adding code in the advanced editor in the power query.

       

      let
    Source = Odbc.Query("dsn=DBASE FILES", "Select * From C:\Test\mytest\m18\IFG.DBF Union ALL Select * From C:\Test\mytest\boj\IFG.DBF Union All Select * From C:\Test\mytest\md2\IFG.DBF"")")
in
    Source

       

      Thanks

       

      Kana

      • 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.