Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

DM Concatenate

Hi All

I have 2 tables like

Table A

Key

Amount

Sales

Table B

Key

Invoice

WorkORader

In my data model if i put Concatenate how data will come (merge or union all) ? please explain with data.Thanks

Table A

Key

Amount

Sales

Concatenate

Table B

Key

Invoice

WorkORader

4 Replies

Re: DM Concatenate

It will union all. If table A had 5 rows, and table B had 7 rows, you will not have 12 rows with 6 fields

Not applicable

Re: DM Concatenate

Table A had 5 rows

table B had 7 rows then my overall 12 records and 5 fields (Key,Amount,Sales,Invoice,WorkORder)

Am i correct ?

Re: DM Concatenate

Sorry yes, 5 fields. You are right

MVP
MVP

Re: DM Concatenate

Concatenate is a set union, which is not quite the same as a SQL union. Fields that exist in only one of the tables will be filled with nulls in the other table. There will be 5 fields n your case (Key exists in both tables). The row count will the sum of the original table row counts.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein