Create CSV File with different Record Types (1 reply)
Tascoli, this is relatively easy. Here are the steps...I assume you're trying to create a file like the screenshot attached.
- After reading the data hierarchise the data (using the hierarchy transform) into your 4 different record types.
- Add a map transform following the hierarchy transform where you add a new field 'RecordType' to EACH transaction. Assign a unique value to the new field on each level.
- In your CSV Writer, ensure RecordType field is the first field...thereby signifying the record type.
Thanks
I need to create a CSV file with 4 different types of records. Any guidance on how to do this?