June 25, 2012 \ Ananth TM 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.