Forum Discussion
Power query . Retrieve a value from other table
Hello, I nedd help for a problem that I couldn't solve.
I have a registration number in the table A
Table A
I have to search this number in the interval on the table B and then I want to bring de date from the table B into table A.
Table B
I prefer do this in power query.
Could someone kindly help me?
In this case go to Table A add a customer column and use the below formula in this column
Table.SelectRows(tableb, (x)=> [data.entrynumber]>=x[from entry n] and [data.entrynumber]<=x[To entry n])
4 Replies
It is easy in power query, just follow the below steps
1. Select table A
2. From home tab, peack Merge command,
3. In the oppend window, in the below box select table B.
4. Select common colmin in both the table and press ok.
Thank you, i find a problem, because the value in the table A is a value between the value in the column "form entry n°" and the value "To entry n°" in the table B. And sometimes the value (table A) may be not be explicit in the table B.
In this case go to Table A add a customer column and use the below formula in this column
Table.SelectRows(tableb, (x)=> [data.entrynumber]>=x[from entry n] and [data.entrynumber]<=x[To entry n])
