You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

HDL Transformation Formula - Fixed length input file

Accepted answer
98
Views
20
Comments
edited Feb 22, 2020 7:43AM in HCM Integrations 20 comments

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!