Hello,
I would like to seperate the txt file shown below into different columns with the tile being the word before the = sign. See below. How can I accomplish this?
Thanks!
Need to conver from this:
To:
How about the attached?
The attached workflow will add a RecordID, split into rows on the space character that is not inside quotes, regex parse splitting on the equal sign, filter the date value vs name value pairs, cross tab the name value pairs, and join the date back in.
Looks like you have the "Join Multiple" tool confused with "Union" tool.
If you need to have separate Input tools, then you want the Union tool to stack the records.
Additionally, you can use a single Input tool if all files are in the same directory. Just use an asterisk * as the wildcard placeholder.
See the attached for an example.
Hi Joe,
Thanks! this solution worked!
I do have a follow up question. I have multiple of these txt files. How can I combined them into one and have them line up in the same Column? When I try to do an Union, each file is showing in a differnt colum.
Thanks
