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
Solved! Go to Solution.
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.
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
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:
Thank you so much @DataNath