Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
What is the difference between concatenate,nonconcatenate,join?
Please explain with an example.
Thanks in advance.
Hi,
Understanding Join, Keep and Concatenate
see these links also..
http://community.qlik.com/docs/DOC-6562
http://community.qlik.com/thread/39177
http://community.qlik.com/thread/134760
Hope it Helps.................
Hi,
Understanding Join, Keep and Concatenate
see these links also..
http://community.qlik.com/docs/DOC-6562
http://community.qlik.com/thread/39177
http://community.qlik.com/thread/134760
Hope it Helps.................
Hi
Please see attache pdf file for your understanding for your review i am sure you will get sufficient information form this attached file.
Thanks
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