Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

when do we use noconcatenate in our data model

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

1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

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.

View solution in original post

7 Replies
Highlighted
MVP & Luminary
MVP & Luminary

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

furtado@farolbi.com.br
Highlighted
Specialist
Specialist

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

Highlighted
Not applicable

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.

Highlighted
MVP & Luminary
MVP & Luminary

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.

View solution in original post

Highlighted
Not applicable

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;

Highlighted
Not applicable

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.

Highlighted

Hi,

Check this for better understanding QlikView Joins

Regards

ASHFAQ