Data arrangement

[Lalaiah]

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

[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.

[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 · Accepted solution]

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:

[Lalaiah]

Thank you so much @DataNath