Data level logical help

[rohan_chavan15]

hi ,

      I have attached the sample data and the required output where i can show as per the required output attached in the file at script level need how can i achieve this please help . Want to show category split in bar chart where if their is a combination of 2 category i want to show it as separate count .

[scotly-victor]

I think this would works.

TI:

load * inline [

MEMBER, CATEGORY, OUTPUT

1, A, A

2, A, A/B

2, B ,A/B

3, C, C

4, A, A

5, B, B

6, C, C/A

6, A, C/A ];

LEFT JOIN

lOAD MEMBER, Concat(CATEGORY,'/') AS NEWOUTPUT RESIDENT TI GROUP BY MEMBER;