Error while executing No Concatenate Keyword !!

[nikhilgarg]

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);

[sushil353]

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

[jagan]

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.

[nikhilgarg]

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.

[jagan]

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.

[er_mohit]

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);

[nikhilgarg]

Hey,

Thanks but in second load we are loading all values and then cross table statement is not working for second table.

Thanks.