Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
HDL Transformation Formula - Fixed length input file
Summary
How to process fixed length input file in the HDL transformation formulaContent
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
1