Not able to append all queries

[Louiselam]

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.

[v-lili6-msft]

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

[Louiselam]

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

[Louiselam]

Dear Lin,

same problem still occurs.

the mapping shows:

"The selection has matched 679987 out of the first 1169420 rows"

Not all the data can map. 😞

[v-lili6-msft · Accepted solution]

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