-

[Yeo-Dong-Eng-Faris]

-

[apathetichell]

Multi-row formula to assign a record id based upon when "SerivceNo" is in jsonstring.

crosstab with ServiceNo as a key field. json string as your columns and json value as your values. put it in concatenate mode because why not.

[mceleavey · Accepted solution]

Hi @Yeo-Dong-Eng-Faris ,

for this you will need to create your grouping and then pivot the data using the Crosstab tool.

This first uses a multi-row formula to create what will become the title field using the following logic:

if [json_string]='"ServiceNo"' then "ServiceNo" elseif [Row-1:json_string]= '"ServiceNo"' then "EstimatedArrival" elseif [Row-1:Title]="EstimatedArrival" then "EstimatedArrival2" else "EstimatedArrival3" endif

This is essentially saying the first section is the ServiceNo, followed by the times split into three.

the second tool uses similar to assign the ServiceNo to each row.

We then pivot the data grouping by the ServiceNo.

I hope this helps,

M.

[Yeo-Dong-Eng-Faris]

-

[mceleavey]

Hi @Yeo-Dong-Eng-Faris ,

I would recommend having a look at the Academy section of the community. You can access that HERE.

Here, you can find interactive lessons, video content and a lot more learning resources that will help you with these sorts of things.

However, you can also follow the workflow through sequentially, click on each tool and see what each one is doing, that will answer your question.

Happy Alteryxing!

M.

[Yeo-Dong-Eng-Faris]

Thanks so much for the assistance 😃

[mceleavey]