Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
HI
Try like below
=Concat(Distinct Aggr(If(SubStringCount(lower(FIRST_NAME), 'b'), FIRST_NAME), FIRST_NAME),',')
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.
Hi
Can you provide sample data and expected output?