HDL Transformation formula reading the input file twice instead of once
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.
0