Forum Discussion

HMK's avatar
HMK
Regular Visitor
3 years ago
Solved

Pulling multiple columns from one (query, tables) into another according to multiple conditions

Hello experts, I'm trying to pull values from column "P05" & "P07" in table 2 to table 1, if the values of the following columns "P00" & "P01" in both tables are identical, and if the values of ...
Need Help
Tips and Tricks
Tutorial Requests
  • TheoC's avatar
    TheoC
    3 years ago

    Hi @HMK 

     

    I've updated the PBIX for you in the attached. I've done it all in Power Query by creating a new key and then Appending the tables into a new table.  PBIX file is attached.

     

    The appended table (new table) looks like below.  You can change / adjust as you want in Power Query, too, by just deleting whatever columns, etc, you don't want.

     

     

     

    Let me know if you need anything else ğŸ™‚

     

     

    Theo

HMK's avatar
HMK
Regular Visitor
3 years ago

Hi TheoC the  'T1'[P02] should start with 'T2'[P02] because  'T2'[P02] contains just the (purchase code) and  'T1'[P02] contains : (purchase code, name, city, date) without the comma symbol
I need the "First" = Left('T1'[P02], LEN('T2'[P02])).
here you can find the PBI file.
Thanks in Advance

TheoC's avatar
TheoC
Icon for Community Champion rankCommunity Champion
3 years ago

Hi HMK 

 

I've updated the PBIX for you in the attached. I've done it all in Power Query by creating a new key and then Appending the tables into a new table.  PBIX file is attached.

 

The appended table (new table) looks like below.  You can change / adjust as you want in Power Query, too, by just deleting whatever columns, etc, you don't want.

 

 

Let me know if you need anything else 🙂

 

Theo