Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2014-11-05 02:02 AM

Difference between concatenate,nonconcatenate,join

What is the difference between concatenate,nonconcatenate,join?

Please explain with an example.

Thanks in advance.

1,165 Views
0 Likes
1 Solution

Accepted Solutions
5 Replies
amit_saini
Master III
Master III
‎2014-11-05 02:05 AM

Check this:

Iframe Without Work Bench license

Thanks,
AS

570 Views
0 Likes
Not applicable
‎2014-11-05 02:11 AM
Author

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

Preview file
1324 KB
570 Views
0 Likes
SunilChauhan
Champion
Champion
‎2014-11-05 02:13 AM

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

Sunil Chauhan
570 Views