Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is it possible to join two cross tables? I have the following (simplified) code that I need to use for several identical tables. I would like to join the tables into one.
CrossTable(FIN_Type, FIN_DATA, 2)
LOAD Account,
Period,
ROAA
From
Hi,
JOIN in the sense all the table have same number of columns with same name?I think Qlikview itself does that job.If it din't done then use concatenate between the tables as below.
TableName:
CrossTable(FIN_Type, FIN_DATA, 2)
LOAD Account,
Period,
ROAA
From
Concatenate
CrossTable(FIN_Type, FIN_DATA, 2)
LOAD Account,
Period,
ROAA
From
Thanks Celambrarasan, your suggestion helped.
I was getting a "Table not Found" error when trying to upload two identical crosstables and load them into seperate QVD files, thus the need to combine them some other way.
Using concatenate with the cross tables produced an "illegal prefix" error...similar to the one found here: http://community.qlik.com/message/3120#3120
The suggestion in that thread fixed the problem. I loaded the two tables with concatenate, and then did a final cross table off of that table. Then dropped the concatenated table.
Thanks for the help!
I am trying to Left Join two cross tables as they do not have identical columns (but share about 90% of them). When I try to do this I get a "Illegal combination of prefixes" error when I try to Reload. Any thoughts?