Hello,
I’m trying to create a data model that combines 4 text files. They will all have a common reference at the beginning of each record line, the fields are delimited by pipes if that’s relevant.
Is the best option to use the preprocessor to bring in the other 3 once I’ve created a data model with the first text file?
Any help/advice would be greatly appreciated. Thanks
Hello @AlphaResponse , an option is to use OL Connect Workflow to concatenate those text files in a single text file using the Send to Folder plugin with the option Concatenate files ticked, use a value extracted from the first line of each text file in the filename of the output file. You can then use a Folder Capture plugin to pick up the output file and to process it by the Execute Data Mapping plugin.
Hi Marten,
Thanks so much for your input.
I apologise for not explaining properly what I’m trying to achieve, 3 of the 4 text data files actually will have multiple lines which will each correspond to one of the lines in the 4th file.
I’ve had some success with writing some javascript which is being used as part of a workflow to create a JSON file which is then fed into a datamapper.