Join three qvd files

[BrianDH]

I have 3 qvd files. (CME_BALANCE, CMEDetailACT, CMEDetailGLX) All three tables have BUSINESS_UNIT & PROJECT_ID.

I am looking for straight forward syntax to join ..ACT, ,,,GLX to Balance.  

AutoNumber((BUSINESS_UNIT) & '_'& (PROJECT_ID)) as MasterKey,

Thanks

[Wlad_Masi]

Hi @BrianDH  here is our help page on JOIN topic: Combining tables with Join and Keep

You will have to choose the approach that better work for you data, we have visual examples on how your data would look like in all the scenarios.