Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Join two tables with same dimensions

i have two tables with the same dimensions but different dates,

how can join these two tables and show the data in the same row

these must be in script

6 Replies
Not applicable
Author

Ola Carlos,

Depends where you have the dates. If the dates are under a dimension with the same name, then you just need a concatenate load.

e.g.

Table:

Load * from table1;

Concatenate (Table)

Load * from table 2;

Hope this helps.

Cumprimentos,

Nuno

swuehl
MVP
MVP

Not sure if I understand your request. Could you post some sample lines of input data? And your requested result?

Anonymous
Not applicable
Author

I have these in load script, but the date in red circle is not in the same row

Clever_Anjos
Employee
Employee

I would concatenate both tables as Nuno FAUSTINO said and then a

LOAD resident agregating the rows

Clever_Anjos
Employee
Employee

OR

Load * from table1;

OUTER JOIN

Load * from table 2;

Anonymous
Not applicable
Author

i will try.

Thanks