Help on parsing output data

Hi! I'm pretty new to Alteryx. Essentially i have a link that i will download data from daily. It gives me data in this form:

***

[{"ColumnA":12345,"ColumnB":"name1","ColumnC":"X","RefDate":"DD-MMM-YYYY","ColumnE":"message"},

{"ColumnA":23495,"ColumnB":"name2","ColumnC":"Y","RefDate":"DD-MMM-YYYY","ColumnE":"message"},

etc

{"ColumnA":12345,"ColumnB":"name1","ColumnC":"X","RefDate":"DD-MMM-YYYY","ColumnE":"message"}]

***

There can be a difference in the number of rows daily.

Can you help advise what Alteryx tool i should use to parse my data to get them into an excel which has the column headings A-E and RefData at the top, with the data at the bottom equal to the number of rows?

Parse

Accepted answers

martinding

Hi @Sohdaw ,

You will need a JSON parse tool and then a series of reporting tools. Please see my attached workflow.

test workflow.png

parsing example.yxmd

All comments

KrishnaChithrathil

@Sohdaw

How should your output look like? can you give us a sample?

ShankerV

Hi @Sohdaw

Can you please paste the sample output expected. Will be easy to work on it.

martinding

Hi @Sohdaw ,

You will need a JSON parse tool and then a series of reporting tools. Please see my attached workflow.

test workflow.png

parsing example.yxmd

PanPP

Hi @Sohdaw

What should your output look like (how would you like to parse this out)?

You can use text to columns or regex. Please see the links below on how to use the tools.

Regex: https://help.alteryx.com/20223/designer/regex-tool

Text to Columns: https://help.alteryx.com/20223/designer/text-columns-tool

Hope this helps! Please like the post if it does.

Sohdaw

This worked! Thanks for enlightening @martinding

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19458

Qiu 15865

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703