Hi Team, I have the data as below and need output below mentioned INPUT. JSON_NameJSON_ValueStringdata.0.fileName904056BE-46BF-4D07-A.pdfdata.0.classificationId-1data.1.fileName939DDFE0-FF51-4D80-A.pdfdata.1.classificationId1584data.2.fileName557AC0DA-CA28-4B5A-B.pdfdata.2.classificationId1464data.3.fileName5A0286DC-E0E3-4224-8.pdfdata.3.classificationId1584 OUTPUT File NameClasificationID904056BE-46BF-4D07-A.pdf-1939DDFE0-FF51-4D80-A.pdf1584557AC0DA-CA28-4B5A-B.pdf14645A0286DC-E0E3-4224-8.pdf1584 Regards, Lalaiah Katam

Data arrangement

Hi Team,

I have the data as below and need output below mentioned

INPUT.

JSON_Name	JSON_ValueString
data.0.fileName	904056BE-46BF-4D07-A.pdf
data.0.classificationId	-1
data.1.fileName	939DDFE0-FF51-4D80-A.pdf
data.1.classificationId	1584
data.2.fileName	557AC0DA-CA28-4B5A-B.pdf
data.2.classificationId	1464
data.3.fileName	5A0286DC-E0E3-4224-8.pdf
data.3.classificationId	1584

OUTPUT

File Name	ClasificationID
904056BE-46BF-4D07-A.pdf	-1
939DDFE0-FF51-4D80-A.pdf	1584
557AC0DA-CA28-4B5A-B.pdf	1464
5A0286DC-E0E3-4224-8.pdf	1584

Regards,

Lalaiah Katam

Developer

Accepted answers

DataNath

Sorry @Lalaiah, had completely overlooked that and hard-coded based on a single digit RecordID which isn't realistic at all! This ought to be dynamic:

Parse and transform JSON data v2.yxmd

All comments

DataNath

Hey @Lalaiah, multiple ways of doing this but here's one:

We can see that the objects follow a structured name which we can use to parse a form of RecordID, as well as the name (filename/classification ID) that we will use as a header in the next step:

Now that we have the information needed to group our data and assign the correct headers, we just configure the Cross-Tab like so:

Finally, we just sort the records back into their correct order:

Hope this helps! Please let us know if you have any questions.

Parse and transform JSON data.yxmd

Lalaiah

Hi DataNath,

Thanks for your solution but its not getting out put for the below.

JSON_Name	JSON_ValueString
data.0.fileName	904056BE-46BF-4D07-A.pdf
data.0.classificationId	-1
data.1.fileName	939DDFE0-FF51-4D80-A.pdf
data.1.classificationId	1584
data.2.fileName	557AC0DA-CA28-4B5A-B.pdf
data.2.classificationId	1464
data.3.fileName	5A0286DC-E0E3-4224-8.pdf
data.3.classificationId	1584
data.5683.fileName	5A0286DC-E0E3-4224-8.pdf
data.5683.classificationId	1584
data.593.fileName	557AC0DA-CA28-4B5A-B.pdf
data.593.classificationId	1464

Regards,

Lalaiah Katam

DataNath

Sorry @Lalaiah, had completely overlooked that and hard-coded based on a single digit RecordID which isn't realistic at all! This ought to be dynamic:

Parse and transform JSON data v2.yxmd

Lalaiah

Thank you so much @DataNath

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703