Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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..
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.
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
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
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.
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.
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;
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.