Transformer Stage using CompactWhiteSpaces

Compact white spaces is the function used in the Transformer Stage function. It will reduce the spaces to the single spaces. 

If we have a data as below 

11,ja mes 
22,lea na 
44,to m 
55,ve nu 
77,t iny 

Take Job design as 


Read and load the data in Sequential file 

In Transformer Stage — Drag and Drop the records to the output file and create 

one column as new_names. In derivation,write expression as below 

compactwhitespaces(e_name) and click ok 

Give file name to the target file and 

compile and run the job to get the required output. 

Leave a Reply

Your email address will not be published.