Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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 ?
Sorry yes, 5 fields. You are right
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.