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