Forum Discussion
Anonymous
3 years agoNot applicable
Power Query : Comparing a column to 2 other columns in other table
Hello,
Please help with the following requirement:
Table 1 : Reference
| Center | CT_B | CT_B+1 | APP_B | APP_B+1 |
| AP1 | B4235 | B4240 | B4321 | B4674 |
| AP2 | B4236 | B4240 | B4321 | B4674 |
| AP3 | B4236 | B4240 | B4333 | B4674 |
| AP4 | B4236 | B4240 | B4323 | B4674 |
| AP5 | B4236 | B4240 | B4321 | B4674 |
| AP6 | B4236 | B4240 | B4321 | B4674 |
| AP7 | B4236 | B4240 | B4321 | B4674 |
| AP8 | B4236 | B4240 | B4321 | B4674 |
| AP9 | B4236 | B4240 | B4321 | B4674 |
| AP10 | B4236 | B4240 | B4321 | B4674 |
| AP11 | B4236 | B4240 | B4321 | B4674 |
| AP12 | B4236 | B4240 | B4321 | B4674 |
| AP13 | B4236 | B4240 | B4321 | B4674 |
| AP14 | B4236 | B4240 | B4321 | B4674 |
| AP15 | B4236 | B4240 | B4321 | B4674 |
| AP16 | B4236 | B4240 | B4321 | B4674 |
| AP17 | B4236 | B4240 | B4321 | B4674 |
| AP18 | B4236 | B4240 | B4321 | B4674 |
| AP19 | B4236 | B4240 | B4321 | B4674 |
| AP20 | B4236 | B4240 | B4321 | B4674 |
Table 2 Center
| Center | Version |
| AP1 | B4236 |
| AP1 | B4236 |
| AP3 | B4236 |
| AP4 | B4236 |
| AP5 | B4236 |
| AP6 | B4236 |
| AP7 | B4236 |
| AP8 | B4236 |
| AP9 | B4236 |
| AP10 | B4236 |
| AP11 | B4236 |
| AP12 | B4236 |
| AP13 | B4236 |
| AP14 | B4236 |
| AP15 | B4236 |
| AP16 | B4236 |
| AP17 | B4240 |
| AP18 | B4240 |
| AP19 | B4240 |
| AP20 | B4240 |
Table 3 APP
| Center | App | Version |
| AP1 | APP1 | Dido 8.2-B-B4236 |
| AP1 | APP2 | Dido 8.2-B-B4236 |
| AP1 | APP3 | Dido 8.2-B-B4236 |
| AP1 | APP4 | Dido 8.2-B-B4236 |
| AP1 | APP5 | Dido 8.2-B-B4236 |
| AP1 | APP6 | Dido 8.2-B-B4236 |
| AP1 | APP7 | Dido 8.2-B-B4236 |
| AP1 | APP8 | Dido 8.2-B-B4236 |
| AP1 | APP9 | Dido 8.2-B-B4236 |
| AP1 | APP10 | Dido 8.2-B-B4236 |
| AP1 | APP11 | Dido 8.2-B-B4240 |
| AP1 | APP12 | Dido 8.2-B-B4240 |
| AP1 | APP13 | Dido 8.2-B-B4240 |
| AP1 | APP14 | Dido 8.2-B-B4240 |
| AP1 | APP15 | Dido 8.2-B-B4240 |
| AP2 | APP16 | Dido 8.2-B-B4240 |
| AP2 | APP17 | Dido 8.2-B-B4240 |
| AP2 | APP18 | Dido 8.2-B-B4235 |
| AP2 | APP19 | Dido 8.2-B-B4235 |
| AP2 | APP20 | Dido 8.2-B-B4235 |
I would like to add the column "Status" to Table 2 as below :
The same Center, if the version in table 2 = [ CT_B] or = [CT_B+1] in Table 1 ==> OK
Table 2 :
Table 3 :
In the same Center, IF The build part in the version ( In red) = 'Table1 Reference'[APP_B] or = 'Table1 Reference'[APP_B+1] ==> OK
Thank you in advance for your help.
Tg