HDL Transformation formula cannot disregard duplicate record from source file
Summary:
HDL Transformation formula cannot disregard duplicate record from source file
Content (please ensure you mask any confidential information):
We are currently receiving a file from external vendor that contains multiple learning record for a learner.
We are loading this file via HDL but we have to use an HDL Fast formula to create the LearningRecord.dat file.
The current HDL FF that we're using is getting "You can't supply multiple data lines for the same record in the same file because the component LearningRecord isn't date-effective." error message.
Is it possible for HDL fast formula to handle duplicate records from an input file and load just one record? For example, if there are 2 or more lines from the source file that have the same data, we want the HDL fast formula to process just 1 record. We want to know how we can do this in the HDL fast formula.