topic Re: when do we use noconcatenate in our data model in QlikView

when do we use noconcatenate in our data model

Tue, 04 Nov 2014 02:30:06 GMT

Hi,

please give me some examples as when do we use noconcatenate in our data model after using it should we drop any fields or tables in order to avoid synthetic keys, give me some real time examples..

Re: when do we use noconcatenate in our data model

afurtado — Tue, 04 Nov 2014 02:55:49 GMT

Hi.

Tables with same fields names QlikView will concatenate.

Using noconcatenate you create 2 tables with same fields.

Some times you can read 1 table like

Tmp:

LOAD * from A;

Final:

noconcatenate

LOAD * Resident Tmp Where field1=10;

drop table Tmp;

of course this is just to show....

Best,

Alessandro Furtado

Re: when do we use noconcatenate in our data model

Anonymous — Tue, 04 Nov 2014 03:17:32 GMT

Hey,

Pls check this

http://www.learnallbi.com/concatenate-and-noconcatenate-in-qlikview-part-2/

Please make your post as correct if this resolves your confusion. So tat others may use it.

Regrds,

Re: when do we use noconcatenate in our data model

Tue, 04 Nov 2014 03:28:00 GMT

TABLE1:

load a,b, c from source1.xls;

TABLE2:

load a, b, c;

sql select a, b, c from aDBTable;

When there are identical fields in different load statements QlikView concatenates subsequent loads with the first in memory table unless noconcatenate is used.

So above there will be only TABLE1 in the data model with second load's records appended to the first.

Re: when do we use noconcatenate in our data model

jagan — Tue, 04 Nov 2014 03:56:41 GMT

Hi,

Generally Qlikview will concatenate the tables automatically if both the tables have same columns, to avoid this NoConcatenate is used.

Example:

TABLE1:

LOAD

a,b, c

FROM source1.xls;

TABLE2:

LOAD

a,b, c

FROM source2.xls;

When the above statements are executed both the tables TABLE1 and TABLE2 are concatenated into 1 table since both the tables have same columns. To avoid this Noconcatenate is used like below

Example:

TABLE1:

LOAD

a,b, c

FROM source1.xls;

TABLE2:

NoConcatenate

LOAD

a,b, c

FROM source2.xls;

You can drop any fields after loading by using the DROP FIELD keyword like below

DROP FIELD Field1;

DROP FIELDS Field1, Field2, ............Fieldn;

Hope this helps you.

Regards,

Jagan.

Re: when do we use noconcatenate in our data model

Tue, 04 Nov 2014 04:06:54 GMT

No concatenation is used for when ever u don't want to join the two tables then we will go for this .

drop the fields like drop field field1,field2,....fieldn;

Re: when do we use noconcatenate in our data model

Tue, 04 Nov 2014 05:01:08 GMT

If we loading tables with same field names in same order, Qlikview can concatenate them automatically.

If we want to combine both, then no use of any key word, it will concatenate automatically.

If we want no concatenation of such tables, we can give key word noconcatenation, between two tables load script.

Re: when do we use noconcatenate in our data model

ashfaq_haseeb — Tue, 04 Nov 2014 05:37:53 GMT

Hi,

Check this for better understanding QlikView Joins

Regards

ASHFAQ