Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
Why not Count(CCY_SETID)?
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;
Hi saran,
This doesnt work
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)
HI
Are you looking something like
Count(Total CCY_SETID)
If not, Can you provide sample data n expected output.
Hi Mayil, this doenst work in script