Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 .
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;