Join two tables with same dimensions

[Anonymous]

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

[#2]

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]

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

[Anonymous]

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

[Clever_Anjos]

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

LOAD resident agregating the rows

[Clever_Anjos]

OR

Load * from table1;

OUTER JOIN

Load * from table 2;

[Anonymous]

i will try.

Thanks