For more information, please refer to this announcement explaining best practices for getting answers to questions.
HDL Transformation Formula With Element Entry to load Multiple Input Values from Single Line
Summary
HDL Transformation Formula With Element Entry to load Multiple Input Values from Single LineContent
I am trying to load Element Entrry using HDL transformation formula.
Input File Is below:
EMPLID|GID|SSN|ERNCD|AMOUNT|SEPCHK|GROSS_UP|DISABLE_DD|REASON_CODE|OFFSET_FLAG|STATE_CODE|ASSIGNMENT_NUMBER|COMMENTS
235XXX|||SAW|100.86|Y|N|||Y||
Multiple Input Value is below :
Amount
Offset Eligible
Pay Separately
Earned Date
Expected HDL File :
METADATA|ElementEntry|AssignmentNumber|EffectiveStartDate|EffectiveEndDate|ElementName|EntryType|LegislativeDataGroupName|MultipleEntryCount|ReplaceLastEffectiveEndDate
MERGE|ElementEntry|E235XXX|2020/05/11|2020/05/24|Siemens Stock Award|E|US Legislative Data Group|2|Y
METADATA|ElementEntryValue|AssignmentNumber|EffectiveStartDate|EffectiveEndDate|ElementName|EntryType|LegislativeDataGroupName|MultipleEntryCount|InputValueName|ScreenEntryValue|ReplaceLastEffectiveEndDate