Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey,
I tries to used "no concatenate" keyword in my small example. But it is showing "illegal use of prefixes" Error. Please help me why it is showing this and what to do ?? My script is :
Directory;
CrossTable(Month, Data)
LOAD Year,
Jan,
Feb,
Mar,
Apr
FROM
Book1.xlsx
(ooxml, embedded labels, table is Sheet1);
NoConcatenate
CrossTable(Month, Data)
LOAD Year,
Jan,
Feb,
Mar,
Apr
FROM
Book2.xlsx
(ooxml, embedded labels, table is Sheet1);
it might be using cross table load ..
Try to use a residence load after getting the table using cross tab..
Also make sure that .. while loading table 2.. make a dummy key say.. '' as temp_key..
and delete it after loading..
HTH
Sushil
Hi,
Try like this
Directory;
CrossTable(Month, Data)
LOAD Year,
Jan,
Feb,
Mar,
Apr
FROM
Book1.xlsx
(ooxml, embedded labels, table is Sheet1);
CrossTable(Month, Data,2)
LOAD Year, 1 as dummy,
Jan,
Feb,
Mar,
Apr
FROM
Book2.xlsx
(ooxml, embedded labels, table is Sheet1);
DROP FIELD dummy;
Hope this helps you.
Regards,
Jagan.
HEy,
THanks but your example is creating sync table and secondly i want to see the usage of non concatenate so i used this example. Please suggest something that contain non concatenate keyword also.
Thanks.
Hi,
What you are trying to do? Before posting in community prepare some sample data and explain it clearly, then only you will get the solution quickly.
QlikCommunity Tip: How to get answers to your post?
NoConcatenate will not concatenate two tables, qlikview automatically concatenates two tables if column names are same in both the tables to avoid this NoConcatenate keyword is used.
If you want to concatenate then use below script
TableName:
CrossTable(Month, Data)
LOAD Year,
Jan,
Feb,
Mar,
Apr
FROM
Book1.xlsx
(ooxml, embedded labels, table is Sheet1);
Concatenate(TableName)
CrossTable(Month, Data)
LOAD Year,
Jan,
Feb,
Mar,
Apr
FROM
Book2.xlsx
(ooxml, embedded labels, table is Sheet1);
DROP FIELD dummy;
If you don't want to concatenate and keep both tables separately then use below script
TableName:
CrossTable(Month, Data)
LOAD Year,
Jan,
Feb,
Mar,
Apr
FROM
Book1.xlsx
(ooxml, embedded labels, table is Sheet1);
Qualify *.*;
CrossTable(Month, Data)
LOAD Year,
Jan,
Feb,
Mar,
Apr
FROM
Book2.xlsx
(ooxml, embedded labels, table is Sheet1);
Regards,
jagan.
Try like this
Directory;
CrossTable(Month, Data)
Table1:
LOAD Year,
Jan,
Feb,
Mar,
Apr
FROM
Book1.xlsx
(ooxml, embedded labels, table is Sheet1);
NoConcatenate
New:
load * ;
CrossTable(Month, Data)
LOAD Year,
Jan,
Feb,
Mar,
Apr
FROM
Book2.xlsx
(ooxml, embedded labels, table is Sheet1);
Hey,
Thanks but in second load we are loading all values and then cross table statement is not working for second table.
Thanks.