How to count IDs by Multiple Language

[shabarish0587]

Hello Everyone,

                         I have a columns like MKT, Language and ID columns, i want to show the data in Pivot Table like where we have two languages in language columns we need to calculate count of ID for the multiple language row. I am attaching sample excel file here.

               Can any one help me on this.Thanks in Advance.

[anat · Accepted solution]

T:
load * Where Len(trim(cnt))>0;
LOAD *,SubField(Language,';',2) as cnt
;
load * Inline [
MKT Language ID
IN-MKT English; 121
IN-MKT English;Hindi 122
IN-MKT Hindi; 122
JP-MKT English 123
JP-MKT English;Japan 123
JP-MKT Japan;English 124
JP-MKT English;Japan 125
US-MKT English;Spanish 126
US-MKT English; 126
UK-MKT English; 127
UK-MKT English;German 128
UK-MKT English;Spanish;German 129

](delimiter is ' ')

[shabarish0587]

Thank you Anant