Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to concat 2 cross tables????
if you load
two cross table then it will automatcally concatenated
or use
if you want then use concatenate in between two tables
Create both Cross Tables seperately and the concatenate it
Hello Manish,
I was wondering if you've already solved the problem. I got the same problem as well. Got a few cross tables and i'm not able to concatenate them.
My colleague found the answer:
Load the cross tables into another tab.
Example:
LOAD *,
'ScoreDB' AS Transactietype
Resident ScoreDB;
Concatenate(Transacties)
LOAD *,
'ScoreCrit' AS Transactietype
Resident ScoreCrit;
Concatenate (Transacties)
Drop table ScoreDB;
Drop Table ScoreCrit;
This worked for me.
hi,
f you load two table with same structure then it will automatically concatenated
else you need to force fully concatenate like
Tab1:
Load
a,b,c
from Tab1;
Concatenate
Load
a,b
from Tab2;
I tried it as well but that didn't work with cross tables. In my case it didn’t concatenate automatically. After I loaded the cross table again I was able to concatenate the tables.