topic Re: syntax in Qlik Compose

syntax

vallikumar — Fri, 14 Mar 2025 20:49:07 GMT

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

Re: syntax

Nanda_Ravindra — Thu, 03 Nov 2022 17:16:08 GMT

@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