Forum Discussion

SHS's avatar
SHS
Icon for Resolver I rankResolver I
6 years ago
Solved

1) Mege Queries 2) Merge Columns creating Unique Values

Hello,    I have 2 queries that I would like to merge in Power Query. Both contains the unique value I will use afterwards. 1 query only contains this unique value once, while the other can have th...
Need Help
  • SHS's avatar
    SHS
    6 years ago

    Hi Mariusz and Yingyinr,

     

    I managed to solve it. The data format for my unique values was not identical before the merge. After ensuring they were identical I didn't have any issues.

     

    But thank you for your support.

     

    Best,

    SHS

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi SHS ,

It seems the data is missing after merged, right? Could you please provide the following information(exclude sensitive data) with screen shots in order to make troubleshooting?

1. Some sample data from these two queries

2. Which join type be chosen when merge queries?

3. What's your expected result?

It is better to provide your sample file if it is convenient.

Best Regards

Rena