Count of a Calculated Measure

[arpita]

Hi

I have a calculated field (CCY_SETID) in my load statement. Now I need to have the total count of (CCY_SETID) . Please help

TLMMO:

LOAD
SET_ID,
IF(Wildmatch(SET_ID,'*GDS*')=1,NULL(),SET_ID) AS CCY_SETID

FROM
$(file)

[Or]

Why not Count(CCY_SETID)?

[Saravanan_Desingh]

Try this,

TLMMO:
LOAD
SET_ID,
IF(Wildmatch(SET_ID,'*GDS*')=1,NULL(),SET_ID) AS CCY_SETID
FROM
$(file)
;

Left Join(TLMMO)
LOAD SET_ID, Count(CCY_SETID) As Cnt
Resident TLMMO
Group By SET_ID;

[arpita]

Hi saran,

This doesnt work

[arpita]

Hi

I have a calculated field (CCY_SETID) in my load statement. Now I need to have the total count of (CCY_SETID) . Please help

TLMMO:

LOAD
SET_ID,
IF(Wildmatch(SET_ID,'*GDS*')=1,NULL(),SET_ID) AS CCY_SETID

FROM
$(file)

[MayilVahanan]

HI 

Are you looking something like 

Count(Total CCY_SETID)

If not, Can you provide sample data n expected output. 

[arpita]

Hi Mayil, this doenst work in script