Forum Discussion
Power query . Retrieve a value from other table
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])
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])
Thank you Omid, it works fine!
