Forum Discussion
Not able to append all queries
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
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
hi, Louiselam
I think you need to use Merge queries instead of Append queries.
For example:
Then expand the table
Result:
Best Regards,
Lin
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. :(
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