We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
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 reading the input file twice instead of once

Accepted answer
123
Views
13
Comments
edited Nov 20, 2019 7:57PM in HCM Integrations 13 comments

Content

Hi All,

I am trying to load a user defined table using HDL transformation formula. The UDT and columns are already setup. Now I want to read the input file and load the rows and column instances.

Input File:

Employee ID|Job Information Effective Date|First Name
100018|05/03/2018|RICHARD
100021|03/22/2013|STEVEN
100025|06/06/2017|RUTHANNE

HDL Transformation Formula in Code snippet and attachment section:

HDL FF.txt

Load Data from File (Log File with ESS_LOG_WRITE function):

HDL log file.txt

Can you please check the Fast Formula, Input file and the log file and let me know where I have gone wrong.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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