May 17, 2014 \ Ananth TM How to Find Numerical Records in the Column If we have a table as below all_num e_id,e_name 11,ram 22,tom 33@#,asli 44,king 54%,remo Take Job Design as Seq.file——-Tx—————Filter————–D.s Read and load the data in Sequential file stage. In Transformer stage Drag and drop the all the columns we have and create one column as num_avl In derivation Write expression as allnum(e_id) Click ok In Filter Stage—- In Where Clause num_avl=1 That’s it Compile and Run the job You wil get the required Output. We get the all the numerical records in the column.