Discussion board where members can get started with Qlik Sense.
Hi, do we have the option to load the column data from one table to another table?
LIB CONNECT TO HIVEODBC;
SQL SELECT ID,
(txt, utf8, embedded labels, delimiter is ',', msq);
( Now as per the above, the two tables gets Join with ID) Here, I want to load the Postcode, Postdesc into the section2 (KMLFile] Table as well, how to achieve it.
Output should be:
[POSTAL DATA] : (ID,Postcode,Postdesc,State,StateDesc) Colums
[KMLFile]: (ID,SADIGIT,LONG,LAT,Postcode,Postdesc), ( 2 (Postcode,Postdesc) columns from [POSTAL DATA] should add to this [KMLFile] Table).
Left join ([KMLFile])
Resident [POSTAL DATA];
Depending on your Data inside you can do join... to learn more check the below link
Different Join Functions in Qlikview
Aehman, Thanks for the response.
I Think Left Join([POSTAL DATA]) right?
Left join ([POSTAL DATA])
//Correct me if I'm wrong.
Left join ([KMLFile]) is correct.
Cus you are joining the below table to KML Table not Postal Table.
after join check if the Data is showing correct. If not check the link I gave and do the appropriate join.
You could try a mapping load.
Mapping LOAD ID,
Applymap('Map_Postcode',ID,0) as Postcode,
Applymap('Map_Postdesc',ID,0) as Postdesc,
I would follow the instructions supplied by Aehman K. The join should work, but you would have to alias a the fields you are joining or it will give you problems with your data model.
Postcode AS KML_Postcode,
Postdesc AS KML_Postdesc
Ya its working by giving alias.
Aron,Thanks for the reply.
I will try this.
Yes, I forgot about changing the name.