Forum Discussion
Helper IHow to Compare two columns from 2 different tables
Abbi here you go https://www.dropbox.com/t/x3YgD9Jf7DsM58i6
Code for Table 1 remains the same. Code for table 2 is updated as followsT2 Dependancy = VAR MissingItems = EXCEPT ( Table2, Table1 ) VAR Result = IF ( HASONEVALUE ( Append1[ID] ), CONCATENATEX ( MissingItems, Table2[Depedency], "," & UNICHAR(10) ) ) RETURN Result
If I solve your problem please consider marking my reply as Accepted. Liks (Kudos) are also appreciated.
Thank you
Helper IHi tamerj1 I have same vales in Dependency but T1 Dependency is taking Client,Engg where as T2 Dependency is taking the vale as Engg,Client.
Please help.
If any other approach please let me know
- tamerj1
Community Champion
Abbi Please clarify further.
Do you mean that under T1 Dependancy you need to see the missing items that are there in Table2 and vice versa?- Abbi
Hi tamerj1 , sorry for causing confusion.
All the Dependencies in Table2 against each id mst be present in the table1.
As per my sample data ID 1234 has Client and Engg as dependencies in T2 , as both of them are present in Table 1 so I dont need it to be displayed.
where as ID 6542 , has Engg as dependency in T2 , and T1 doesnt have Engg as depedency against ID 6542 in table 2 so We have to display it
- tamerj1
It is now clear. Will get back to you as soon as I can.