How to find the Alphabetic Records in the column

In order to find the alphabetic records in the column, we have a Alpha Function. 


By using Alpha Function, we can find the number of alphabetic records we have in the required column. 


Take Job Design as below 


Seq.File—– Tx—– Filter—— D.s 




If we have a table as below 

alpha_tabl 


e_id,e_name 
11,james 
22,leana121 
33,lacky11 
44,tom 
55,venu 
66,emy211@ 
77,tiny@ 

Read and Load the data in the Sequential file 


In transformer Stage drag and drop the records to the Output file and create one column as new_names 


In Derivation write as alpha(e_name ) Click ok 


In Filter Stage— In Where Clause 


Write as new_names=1 


And don’t forget to drang and drop the records in Output 


Thats it click ok 


Compile and Run the Job to get required Output. 

Leave a Reply

Your email address will not be published. Required fields are marked *