Forum Discussion

Louiselam's avatar
Louiselam
Frequent Visitor
7 years ago
Solved

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 ...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    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

Louiselam's avatar
Louiselam
Frequent Visitor
7 years ago

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's avatar
    v-lili6-msft
    Community Support
    7 years ago

    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