topic Error while executing No Concatenate Keyword !! in QlikView

Error while executing No Concatenate Keyword !!

nikhilgarg — Mon, 22 Sep 2014 05:54:52 GMT

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

Re: Error while executing No Concatenate Keyword !!

sushil353 — Mon, 22 Sep 2014 06:09:19 GMT

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

Re: Error while executing No Concatenate Keyword !!

jagan — Mon, 22 Sep 2014 06:10:46 GMT

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.

Re: Error while executing No Concatenate Keyword !!

nikhilgarg — Mon, 22 Sep 2014 06:21:46 GMT

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.

Re: Error while executing No Concatenate Keyword !!

jagan — Mon, 22 Sep 2014 06:31:57 GMT

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.

Re: Error while executing No Concatenate Keyword !!

er_mohit — Mon, 22 Sep 2014 06:53:31 GMT

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

Re: Error while executing No Concatenate Keyword !!

nikhilgarg — Mon, 22 Sep 2014 07:01:15 GMT

Hey,

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

Thanks.