topic Re: Inserting values from one table into another in QlikView

Inserting values from one table into another

brunolelli87 — Tue, 06 Apr 2021 22:14:01 GMT

Hello guys,

I have one table with the following fileds:

KEY	DEP	ARR
001AS	VCP	GIG
035SD	MAO	BEL
037SD	REC	POA

And another table with the following fields:

APT	LAT	LONG
VCP	-27.24	-47.78
MAO	-23.88	-20.25
REC	-22.15	-15.33
BEL	-22.14	-33.66
GIG	-14.35	-15.78
POA	-24.53	-22.25

How can I get the values of LAT and LONG of each airport and update the first table including LAT and LONG for DEP and ARR, creating something like:

KEY	DEP	ARR	LAT DEP	LON DEP	LAT ARR	LON ARR
001AS	VCP	GIG	-27.24	-47.78	-14.35	-15.78
035SD	MAO	BEL	-23.88	-20.25	-22.14	-33.66
037SD	REC	POA	-22.15	-15.33	-24.53	-22.25

Thank you guys,

Re: Inserting values from one table into another

Saravanan_Desingh — Tue, 06 Apr 2021 23:04:45 GMT

One solution,

tab1: LOAD * INLINE [ KEY, DEP, ARR 001AS, VCP, GIG 035SD, MAO, BEL 037SD, REC, POA ]; Left Join(tab1) LOAD APT As DEP, LAT As [LAT DEP], LONG As [LONG DEP]; LOAD * INLINE [ APT, LAT, LONG VCP, -27.24, -47.78 MAO, -23.88, -20.25 REC, -22.15, -15.33 BEL, -22.14, -33.66 GIG, -14.35, -15.78 POA, -24.53, -22.25 ]; Left Join(tab1) LOAD APT As ARR, LAT As [LAT ARR], LONG As [LONG ARR]; LOAD * INLINE [ APT, LAT, LONG VCP, -27.24, -47.78 MAO, -23.88, -20.25 REC, -22.15, -15.33 BEL, -22.14, -33.66 GIG, -14.35, -15.78 POA, -24.53, -22.25 ];

Re: Inserting values from one table into another

Saravanan_Desingh — Tue, 06 Apr 2021 23:05:18 GMT

Output: