Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
bhavvibudagam
Creator II
Creator II

concatenate expression

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.

1 Solution

Accepted Solutions
its_anandrjs

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.

View solution in original post

2 Replies
sunny_talwar

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

its_anandrjs

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.