Forum Discussion
Not able to append all queries
Hi,
I have appended one table to the other to get the Column " Application" map in my primary table. The unique key is "Resource Group Calculated" column.
However, some of the rows not able to map with the application.
Example:
After appended the application column:
Row 1 - RG 1 - successfully map to the correct application name
Row 2 - RG 1 - "Null"
So only 1 row for each unique key are able to map to the application name.
Would anyone know why there are data missing?
thanks.
hi, Louiselam
"The selection has matched 679987 out of the first 1169420 rows"
This means that there are 1169420 rows in table1 but only 679987 rows in table1 can be matched with table2.
So please check if all the values in RG have the same value in table, capital and lower-case letter will also affect the result.
For example:
I change rg-eas-pd-DEF to rg-eas-pd-DEf
this will lead to not all the data can map
Best Regards,
Lin
5 Replies
v-lili6-msftCommunity Support
hi, Louiselam
I have tested on my side, but not reproduce the issue.
Could you please share some screenshots or some sample data and expected output. Do mask sensitive data before uploading
Best Regards,
Lin
Dear Lin,
I am trying to append table 2 into table 1, with unique key in Column "RG" in both tables.
Example:
Table 1
RG Day Month Cost rg-eas-pd-123 1 1 15 rg-eas-pd-ABC 1 1 16 rg-eas-pd-DEF 1 1 20 rg-eas-pd-123 2 1 34 rg-eas-pd-ABC 2 1 13 rg-eas-pd-DEF 2 1 15 rg-eas-pd-123 3 1 16 rg-eas-pd-ABC 3 1 20 rg-eas-pd-DEF 3 1 34 rg-eas-pd-123 4 1 13 rg-eas-pd-ABC 4 1 34 rg-eas-pd-DEF 4 1 13 Table 2
RG Application rg-eas-pd-123 123 rg-eas-pd-ABC ABC rg-eas-pd-DEF DEF Current issue
Some of the rows unable to map with application
RG Day Month Cost Application rg-eas-pd-123 1 1 15 123 rg-eas-pd-ABC 1 1 16 ABC rg-eas-pd-DEF 1 1 20 DEF rg-eas-pd-123 2 1 34 Null rg-eas-pd-ABC 2 1 13 Null rg-eas-pd-DEF 2 1 15 Null rg-eas-pd-123 3 1 16 Null rg-eas-pd-ABC 3 1 20 Null rg-eas-pd-DEF 3 1 34 Null rg-eas-pd-123 4 1 13 Null rg-eas-pd-ABC 4 1 34 Null rg-eas-pd-DEF 4 1 13 Null
Thanks- v-lili6-msft
hi, Louiselam
I think you need to use Merge queries instead of Append queries.
For example:
Then expand the table
Result:
Best Regards,
Lin
