Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Louiselam
Frequent Visitor

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.

1 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

6.JPG

 

 

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

5 REPLIES 5
v-lili6-msft
Community Support
Community 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

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Dear Lin,

 

I am trying to append table 2 into table 1, with unique key in Column "RG" in both tables.

 

Example: 

Table 1

RGDay MonthCost
rg-eas-pd-1231115
rg-eas-pd-ABC1116
rg-eas-pd-DEF1120
rg-eas-pd-1232134
rg-eas-pd-ABC2113
rg-eas-pd-DEF2115
rg-eas-pd-1233116
rg-eas-pd-ABC3120
rg-eas-pd-DEF3134
rg-eas-pd-1234113
rg-eas-pd-ABC4134
rg-eas-pd-DEF4113

 

Table 2

RGApplication
rg-eas-pd-123123
rg-eas-pd-ABCABC
rg-eas-pd-DEFDEF

 

Current issue

Some of the rows unable to map with application

RGDay MonthCostApplication
rg-eas-pd-1231115123
rg-eas-pd-ABC1116ABC
rg-eas-pd-DEF1120DEF
rg-eas-pd-1232134Null
rg-eas-pd-ABC2113Null
rg-eas-pd-DEF2115Null
rg-eas-pd-1233116Null
rg-eas-pd-ABC3120Null
rg-eas-pd-DEF3134Null
rg-eas-pd-1234113Null
rg-eas-pd-ABC4134Null
rg-eas-pd-DEF4113Null


Thanks 

hi, @Louiselam

I think you need to use Merge queries instead of Append queries.

For example:

3.JPG

Then expand the table

4.JPG

 

Result:

5.JPG

 

Best Regards,

Lin

 

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

6.JPG

 

 

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.