topic Re: Difference between concatenate,nonconcatenate,join in QlikView

Difference between concatenate,nonconcatenate,join

Wed, 05 Nov 2014 07:02:18 GMT

What is the difference between concatenate,nonconcatenate,join?

Please explain with an example.

Thanks in advance.

amit_saini — Wed, 05 Nov 2014 07:05:47 GMT

Check this:

Thanks,
AS

Nagaraju_KCS — Wed, 05 Nov 2014 07:06:27 GMT

Hi,

see these links also..

Hope it Helps.................

Wed, 05 Nov 2014 07:11:41 GMT

Please see attache pdf file for your understanding for your review i am sure you will get sufficient information form this attached file.

Thanks

SunilChauhan — Wed, 05 Nov 2014 07:13:49 GMT

concatenate: if have two table with same name then it auto concatenated and rows appended to one table

thoug qlikview will displays distinct record .frequency will be diffrent

we could force using concatenate when tabled have different column

No Concatenate: it will not appent rows to first table although fields are same. w have different tables

join: based on key value insert second table into first.only matching record will be there

ashfaq_haseeb — Wed, 05 Nov 2014 07:18:08 GMT

Hi,

Check this

Regards

ASHFAQ