So I am working on a project with 52 files that are essentially orders, (each order has two files designated to the order). I want to connect the two files together since it represents one order but I want to do it to all 26 orders. Just to note, the files are text files with XML format but they are all formatted differently. I have attached the workflow I currently have that parses the UI data out and also the Input data. I have also attached a link to a google drive that includes a folder of all the raw files.
In summary, I want to connect SQTBY000357-1_Line1_InputXML.txt and SQTBY000357-1_Line1_UIDataXML.txt. I am assuming there could be a way to combine the files in a way that will reference the file name such as "contains Line1_ in file name" or something along those lines. I want to also do this for the rest of the files Line1_ through Line26_.
https://drive.google.com/drive/folders/1vEaGFfPKTST6MjD4FoDnofC0R47ZabW6?usp=sharing
If further information is needed please let me know.
