Find list of values from one table that are not present in another table

[kinjal1645]

Hi,

I have two tables A and B

Table A
Test3
Test4
Test5

Table B
Test1
Test2
Test3
Test5

I want list of values from table B that are not present in table A.

This needs to be done without changing data model. May be with set analysis, set operators,..?

Required output: Test1 Test2

Kindly help!

[MK_QSL]

are both field names same?

[kinjal1645]

Field names are different

[MK_QSL · Accepted solution]

Try this

I considered both field names Table A and Table B.

You can change accordingly.

=Concat(Distinct Aggr(IF(SubStringCount(Concat(DISTINCT [Table A],', '),[Table B])=0,[Table B]),[Table B]),', ')

[kinjal1645]

Thank you!!
It worked