Restrucutre flat table (after JSON to Table)

AndreAndre · March 3, 2025, 2:08pm

Hi!
I would like to restructure my flat table, whose data I have extracted from a JSON file.

I’m struggling to find an efficient solution to have one column per language.

Which method would you choose to reach your target?

Left table shows the ACTUAL situation.
Right table the TARGET situation.

Thanks in advance

Andre

rfeigel · March 3, 2025, 2:56pm

Could you please provide some sample input and desired output? That would make it easier for potential helpers.

AndreAndre · March 3, 2025, 3:10pm

Hi, yes. Thanks for the hint.

Add94 · March 3, 2025, 4:12pm

Hey @AndreAndre , have a look at the attached
json to table to piviot.knwf (60.1 KB)

rfeigel · March 3, 2025, 5:34pm

This works, but its totally manual and brute force. As far as I could see your input data has no discernable pattern on which to automate.

AndreAndre · March 5, 2025, 3:21pm

Hi @Add94 , Hi @rfeigel ,
sorry for the delay of my reaction.
I will check your solution at least on friday.
BR
Andre