DM Concatenate

[#1]

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

[sunny_talwar]

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

[#3]

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 ?

[sunny_talwar]

Sorry yes, 5 fields. You are right

[jonathandienst]

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.