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
Skip to content
  • Register
    • Get Started: AI Resources for Oracle Cloud HCM – Go Here

    Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

    HDL Transformation Formula - Fixed length input file

    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
    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

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