Separate txt file into columns with titles

[dan_b]

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:

[Joe_Mako · Accepted solution]

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.

[dan_b]

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 

[Joe_Mako]

Does http://community.alteryx.com/t5/Alteryx-Knowledge-Base/Reading-multiple-CSV-files-at-once/ta-p/38221 help?

If not, can you attached a workflow and sample files that reproduce the situation you have? Thank you!

[dan_b]

Here is what I'm trying to do , attached is the workflow. 

[dan_b]

Here is what I'm trying to do , attached is the workflow. 

[Joe_Mako · Accepted solution]

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.

[dan_b]

Thanks! The wildcard worked!