cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

retrieve one column after matching multiple column between two tables

I have tow table-a (ex : Column1- 10)  Table-b (Column 1-5(same value as columnA)  and two additional colum (Col X, ColY)

 

I need add Col- X after matching Table-a(column1-5) and  Table(column1-5). Note:  both tablea, table b  columns (1-5)has Many to many releation ship.

Table-a     1 2 3 4 5 A A A A B

                  1 2 3 4 5 A A A B B

Table -b       1 2 3 4 5 X1 Y1

                  1 2 3 4 5 X2 Y2

What is the best method to retirve Col X 1, X2, Y1, Y2 after matching 1-5 column of Table-a and Table-B

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Helper I
Helper I

Re: retrieve one column after matching multiple column between two tables

working fine. Concatnate matching column using query editor and used lookupfunction.

View solution in original post

3 REPLIES 3
Highlighted
Community Champion
Community Champion

Re: retrieve one column after matching multiple column between two tables

HI @vinothkkri 

 

You can concatenage these 5 column in both table and create a relationship between these two.

Then arriving at the logic to get X1,Y1, X2 and Y2 will become easier.

 


Hope it resolves your issue? Please consider accepting it as the solution to help the other members find it more quickly.


Appreciate your Kudos, Press the thumbs up button!!👍


Regards,
Pranit


Highlighted
Helper I
Helper I

Re: retrieve one column after matching multiple column between two tables

Thanks for reply.  Concatnate only work with two strings and still not sure even after i merge column value (any other method) how this will work. Note: My table A- Update on real basis.  Table -B is static., so when new row added into table-A, i need to fetch corresponding value from Table B

Highlighted
Helper I
Helper I

Re: retrieve one column after matching multiple column between two tables

working fine. Concatnate matching column using query editor and used lookupfunction.

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors