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