JSON Grouping

Hi Knime Users,

This data consists of Metrics and their respective submetrics.

The metrics are “AHT, Autopay, CSAT, Adherence, Attendance, QA, FCR, Chargeable Transactions”
image

this is the workflow that I am using to get that format.

My question is, how do i get it do that the submetrics are grouped under the respective metrics.

please let me know if you any more questions. I would be happy to clarify.

Hi there @parthak,

just to see if I got it right. You would like everything between AHT and Autopay to become sub-metric of AHT or? Ideally can you share data input example and desired output?

Br,
Ivan

1 Like

Hi @ipazin

actually you got it right the first time.

Everything between AHT and Autopay becomes a submetric of the AHT group
like everything between Autopay and CSAT becomes a submetric of Autopay and so on and so forth.

The input is in the following format:

rogerscor.xlsx (8.6 KB)

@ipazin

I have attached an excel file of the input data for your reference

Hi there @parthak,

and what about desired output? Can you also share (workflow) what you currently done with this input? You could probably use JSON Transformer to obtain your desired format but I’m not sure which one is that exactly…

Br,
Ivan

1 Like

Hi @ipazin

image

i have attached a snippet of the desired output format.

i have also attached the workflow. json format.knwf (17.0 KB)

1 Like

I just tired using the json transformer, but I was not able to get proper output.

Please let me know if you have any inputs

Hi there @parthak,

hmm… Don’t think JSON Transformer will help here but rather using some string manipulations prior to turning data into JSON could. Can you share workflow which is not in state reset and I can give it a try but no promises…

Br,
Ivan

1 Like

Duplicate: table to JSON with structure