HDL Transformation formula reading the input file twice instead of once
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.
Employee ID|Job Information Effective Date|First Name
HDL Transformation Formula in Code snippet and attachment section:
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.