Hi everybody, I received a dataset with the following order below. RecordJSON NameJSON Value String10.adtagID656520.distinctpageseen130.firsttimeseen2020-02-0540.lasttimeseen2020-02-0551.adtagID658761.distinctpageseen171.firsttimeseen2020-02-0581.lasttimeseen2020-02-0591.profiletime1 I would like to convert it into sth like this: RecordAdTagIDDistinctpageseenfirsttimeseenlasttimeseenprofiletime1656512020-05-052020-05-05N/A2658712020-05-052020-05-051 I tried to use couple of functions but not able to solve. As a new user I need some help:) Thanks in advance. Kutay

Cross Tab columns with ID Numbers, Values and Date

Hi everybody,

I received a dataset with the following order below.

I would like to convert it into sth like this:

I tried to use couple of functions but not able to solve. As a new user I need some help:)

Thanks in advance.

Kutay

Workflow

Datasets

Gallery

Regex

Parse

Hi David,

Thank you so much for your help. I tried and it worked perfectly!

Kind Regards,

Kutay

The key is to separate JSON Name with Text to columns, then crosstab

Hi @Kutay I mocked up a workflow that shows how to do this.

Hi David,

Thank you so much for your help. I tried and it worked perfectly!

Kind Regards,

Kutay

Thank you so much Joseph! I tried your solution as well and helped me a lot too!

Kind Regards,

Kutay