when do we use noconcatenate in our data model

[#1]

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..

[afurtado]

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

[Anonymous]

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,

BR

[#4]

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.

[jagan · Accepted solution]

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.

[#6]

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;

[#7]

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.

[ashfaq_haseeb]

Hi,

Check this for better understanding QlikView Joins

Regards

ASHFAQ