syntax

[vallikumar]

Hi all

I have two tables and i need to extract particular column from both the tables

and create new table in the same script 

table 1:

id	date	name
1	10/12/2022	kk
2	10/13/2022	rr
3	10/14/2022	kl

  table 2:

COUNTY	DATE	NAME
UK	10/15/2021	SHIVA
INDIA	10/16/2021	HARI
US	10/19/2021	KUMARA

i need results like this 

results:

date	DATE
10/12/2022	10/15/2021
10/13/2022	10/16/2021
10/14/2022	10/19/2021

[Nanda_Ravindra · Accepted solution]

@vallikumar This form is for Qlik Compose for Data warehouse. Based on what you are asking , it looks like, your question is more about a  table join . If this not correct, please clarify exactly what you are trying to accomplish in Qlik Compose with the 2 tables you have mentioned?

If this is a table join question, you can use a "UNIO"  to merge information from multiple tables. This is technically not a join. Hope this helps!

Thanks,

Nanda