how to combine multiple data sources and tables in one query in a power query

[roykana]

Elaborate "How do I want to custom the columns for each dbf table. ". If you mean you need custom column for each DBF file that's being unioned. That's not really Excel question, as you'll need to write SQL Statement for DBF.

Any Union can only be done for table with same structure. If it isn't, you can't.

Depending on data, you can perform join. But that really depends on data structure. But again, that's not really an Excel quesion anymore

you mean sql statement in the power query for the custom column

 

[Chihiro]

No

 

[roykana]

No

for this question you have not answered
How to vlookup formula in m language without making unpivot.

you can see in sheet "SAMPLE VLOOKUP WITH FORMULA".

 

[roykana]

this my file excel

 

[roykana]

No

Dear mr chihiro,
for this question you have not answered
How to vlookup formula in m language without making unpivot and can I used dax formula?

you can see in sheet "SAMPLE VLOOKUP WITH FORMULA".
Thanks

Roykana

 

[Chihiro]

Just join based on column(s). (i.e. merge operation).

https://support.office.com/en-us/ar...er-query-fd157620-5470-4c0f-b132-7ca2616d17f9

 

[vletm]

roykana
You would reread

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...

chandoo.org

especially Always -part.
There are few sentences, which You seems to forget.