Substringcount()

[mithunr40]

I want to show the list of employees whose name contains letter 'b' (case insensitive/they will be displayed distributed by COUNTRY_NAME). They given to me the fields and the functions to use in set analysis: EMPLOYEE_ID,FIRST_NAME,concat(),SubStringCount(),lower().

Please help me to solve this problem.

Thank you.

[MayilVahanan]

HI

Try like below

=Concat(Distinct Aggr(If(SubStringCount(lower(FIRST_NAME), 'b'), FIRST_NAME), FIRST_NAME),',')

[mithunr40]

Thank you for your answer @MayilVahanan  but the output is wrong and i think they have mentioned country_name also so please check and help me to solve the problem.

[MayilVahanan]

Hi

Can you provide sample data and expected output?