Compare two straight tables and provide the non matched ones in another table

[Anonymous]

Hi All,

Is it possible to compare two straight tables and proved the non matched ones in another table (in GUI)

For eg:

I have the following two tables(sample data):

TableA:

Pol Number	Amount	Name
AB123	345	AB
AC234	567	AC
DF876	1000	DF
AV001	533	AV
BN09	5746	BN

Table B:

Pol Number	Amount	Name
AB123-002	563	AB
AC234-002	234	AC
AV001-002	786	AV

So i need match the above two tables- Table A contains the pol numbers and if they are renewed for the next term then its populated with -002 (Table B)

So now i need to have another straight table which compares and provides the details of the pol numbers which isnt available in the table B.

So the Table C should contain the following records:

Pol Number	Amount	Name
DF876	1000	DF
BN09	5746	BN

Kindly let me know if this is possible.

Thanks in advance!

Anupama Jagan

[sunny_talwar]

It should be possible, would you be able to share a sample app to test this out?

[mdmukramali]

Hi,

Maybe one way.

=Count({<[Pol Number]={"=Count([Pol Number])=1"}>}[Pol Number])

Thanks,

Mukram.

[Anonymous]

Im afraid i will not be able to share app because i have QV installed in my client machine.

I can provide the sample data which i have put it in the above tables:

Pol Number	Amount	Name
AB123	345	AB
AB123-002	563	AB
AC234	567	AC
AC234-002	234	AC
DF876	1000	DF
AV001	533	AV
AV001-002	786	AV
BN09	5746	BN

So table A has the Pol Numbers without -002 and table B has only -002 ones( those are typically renenwed ones)

I need another table just to find which didnt make to renewals(basically which arent there in the table B)

[Anonymous]

should i put this expression in a new table?

[mdmukramali]

Hi,

PFA.

[Anonymous]

Actually both of the tables are in UI. Is it possible to compare the tables in UI rather than going to script?

[mdmukramali]

Hi,

i have done it in UI Only ,

[sunny_talwar]

May be try with this

=Count({<Name = {"=Count([Pol Number])=1"}>}[Pol Number])

[sunny_talwar]

Modified the sample attached by mdmukramali‌.. see if this looks good

=Count({<Name = {"=Count([Pol Number])=1"}>}[Pol Number])