concatenate expression

[bhavvibudagam]

Hi Experts,

Can anyone please help me on this.

From the concatenate expression output need to delete the pink color records

Concatenate expression:

=[Cov Group]&' '&[Cap Group]

output

Corps

FS

Audit

KBS

'Solutions & Digital'

Corps Audit

Please let me know how to proceed.

Thanks in advance.

[sunny_talwar]

Not entirely sure I understand, do you have a sample to elaborate?

[its_anandrjs · Accepted solution]

After concatenation load another table and filter this rows

Ex:-

Load

*

Resident TableName

Where Not Match([Cov Group]&' '&[Cap Group],'Corps','FS,Audit','TPL','Consulting','Deal Adviosory');

Drop Table TableName;

But it better you can create any flag field on the table and then use that flag to filter those rows, May be good idea.