Create spreadsheet from raw txt file

Hi here is a sample txt file - I created false data values. Hopefully this mock dataset should help. Thank you so much!

Sample.txt

Hi @mzsweetumz

This is what I usually do with JSON:

New Workflow6.yxmd

All comments

uncheck "first row contains field names"

I did that and continued working on the workflow but am stuck with an output that does not make sense still:

based off my txt file, there should a couple more unique rows

output should look like this:

any advice?

Thank you!

What are your cross tab configurations?

The number in the json name should probably be grouped by, the data is probably items_0_assignee, items_1_assignee, etc.

what's your json tool configuration too?

Hi @mzsweetumz hmmm. I think you might need to parse the Json differently - usually you want to pull all the json values into one field and the json names into another (depending upon what you are trying to do) - and then crosstab based upon that - with a unique id that relates to rows. I can't tell the specifics from the schema that you pictured.

If you can post one record of sample json - I'm sure @Luke_C or I could set up a workflow for you - or give you a pointer to what you should be swapping and where.

Hi here is a sample txt file - I created false data values. Hopefully this mock dataset should help. Thank you so much!

Sample.txt

Hi @mzsweetumz

This is what I usually do with JSON:

New Workflow6.yxmd

This is similar. It includes the multi-formula to make ID into a counter and I split up the different JSON types for variable consistency.

sample json.yxzp

Thank you so much Luke!! This workflow helped me tremendously and was able to get me exactly what I needed.

Very much appreciate your help with this.

Thank you so much!!

Hi @Luke_C and @apathetichell ,

I am having trouble parsing another txt file into rows and columns. This time the data looks like xml format but is a txt file. The workflow that you provided helped with my other txt file, but does not apply the same logic to this one. I tried doing it a different way but cannot seem to figure it out.

I attached the sample data here: xml version.doc (for some reason it is not allowing me to upload txt files at the moment)

xml version.docx

https://help.alteryx.com/20214/designer/xml-parse-tool

Hi @mzsweetumz

Yes, XML would be handled differently than JSON. I don't have much experience dealing with XML files, however there is a specific XML parse tool and 2 weekly challenges that might help show you what you need to do.

https://community.alteryx.com/t5/Weekly-Challenge/Challenge-37-Parsing-a-Raw-XML-File/td-p/36577

https://community.alteryx.com/t5/Weekly-Challenge/Challenge-195-XML-Parsing/td-p/505892