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. 

Leave a Reply

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