Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Not sure if I understand your request. Could you post some sample lines of input data? And your requested result?
I have these in load script, but the date in red circle is not in the same row
I would concatenate both tables as Nuno FAUSTINO said and then a
LOAD resident agregating the rows
OR
Load * from table1;
OUTER JOIN
Load * from table 2;
i will try.
Thanks