Seperate and count the delimited values using front end expression

[#1]

Hi Team,

Is it possible to get below given output from the input data using front end expression.

[#2]

Hi Sushil,

Distinct values need to be counted not the comas. This is not working.

Thanks,

Anoop

[#3]

Hi Sushil,

Since I need to count the distinct values from the coma separated value this method is not working,

it is failing in the below scenario.

[Step 1]:

LOAD * INLINE [

    Emp_Name, Dept_List

    EMP1, "A, B, C"

    EMP1, "A, B"

    EMP2, "D, C, A, D, E,E,E,E"

];

Its just counting the comas in the string.

Thanks,

Anoop

[#4]

Tresesco,

Exactly, its going to be a bit tricky to be solved using front end expression.

Thnaks,

Anoop

[#5]

Hi Avinash,

If I have to handle this in script level, I will be ending up adding a big table, only for accommodating these split values.

It will be fine for a smaller data set where as my application is dealing around 15 million records.

Currently I have solved the issue using this method only but need to check a better way to optimize the performance.

Thanks,

Anoop