My issue is that not all pairs are always present. They always have a groupNBR and a language but the next record may not, for example, have a record for 'imagePrimary' or 'sectionName' so it needs to be able to cope with varying record format.
I have found MaheshMP's tFileInputKeyValue custom component and though it works very well in foreground mode, it returns corrupted data when run as an exported job. Some files complete, others fail completely or have partial data. It does not error and I have not been able to identify the cause.
Does anyone have any recommendations for how I could use standard components to solve this please, or any other suggestions?
Worked it out myself... Create a dummy record as the first record of the data file with all the possible Key Value pairs in the required order. Can then use tPivotToColumnsDelimited to generate the records. As long as the dummy values are at the beginning of each file, the format will always match.
