HDL Transformation Formula - Fixed length input file

Summary

How to process fixed length input file in the HDL transformation formula

Content

Hi,

So far we have processed delimited files using HDL transformation formula. But, we do receive fixed length files from other system that needs to be loaded into HCM cloud. What we need to pass for file type and how to read the lines in the HDL transformation formula?

Any help is much appreciated!

IF OPERATION='FILETYPE' THEN

OUTPUTVALUE='DELIMITED'

ELSE IF OPERATION='DELIMITER' THEN

OUTPUTVALUE='|'

ELSE IF OPERATION='READ' THEN

OUTPUTVALUE='NONE'

 

Thanks!

Murali