Qlik Community

Qlik DataMarket Discussions

Discussion Board for collaboration regarding Qlik DataMarket.

sagarrahul
New Contributor III

same names appearance

hiiiiiiii ,

having certain problem

below is my table where there first name and last name is in one column only .

custname
sagar rahul
rahul sagar
r sagar
s rahul

so we want to check by taking first name at a time or taking last name at time what things are coming as output

eg :

lets us take sagar so we want to check how many time is coming in the custname column .

so it should give me , all below which are having sagar will appeared

result
sagarrahul
rahulsagar
rsagar

so after we take rahul  , all below which are having rahul will appeared

 

sagarrahul
rahulsagar
srahul

so need help .

Community Browser