topic Join two tables with same dimensions in QlikView

Join two tables with same dimensions

Anonymous — Wed, 09 Oct 2013 21:27:02 GMT

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

Wed, 09 Oct 2013 21:39:05 GMT

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 — Wed, 09 Oct 2013 21:40:52 GMT

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

Anonymous — Wed, 09 Oct 2013 21:48:04 GMT

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

Clever_Anjos — Wed, 09 Oct 2013 21:59:06 GMT

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

LOAD resident agregating the rows

Clever_Anjos — Wed, 09 Oct 2013 22:03:38 GMT

Load * from table1;

OUTER JOIN

Load * from table 2;

Anonymous — Thu, 10 Oct 2013 12:30:04 GMT

i will try.

Thanks