Data Load Editor Query help

[HMUTUAL01]

I am trying to create a data set  based on 3 tables and need some help as I am a novice. I have a customer purchases, customer sales  and address table .  I would like to create a table which is groups the customer sales and purchases by the state which is in the address table. 

example of result would be:

State    Purchase      Sales

TX           $10                  $17

CA           $33                   $92 

[RamanaKumarChintalapati · Accepted solution]

Hi @HMUTUAL01 ,

Please find the below script for to create a dataset based on three tables.

NoConcatenate
Temp:
Load
"Purchase Units"
resident [Customer Purchase];
Join
Load
Sales
resident [Customer Sales];
Join
Load
State
Resident [Address table];
NoConcatenate
Temp1:
Load
"Purchase Units",
Sales,
State
Resident Temp;
Drop table Temp;
Exit Script;

Still any doubts about this topic ,Please go through the below link  for your better understanding-

https://community.qlik.com/t5/QlikView-App-Dev/Understanding-Join-Keep-and-Concatenate/td-p/328379

thanks!!!

[Sivapriya_d · Accepted solution]

Is there any specific reason you want do it in the back end.
I assume these tables have common keys in between them . If so Qlik will associate these tables based on the common name and in the front end table chart you can use the fields from any of the tables.
Make sure there is no synthetic keys/circular reference.