Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hey!
I want to expand three values from a field in a JSON column of a table and add these three values as new columns into the table. The javascript is constructed in the same way all the time. So as an example:
The javascript looks like this:
{ "type": "XXX", "currenttype": 0, "typecontent": [ { "angleSide": "none", "direction": "none", "size": { "x": XXX, "y": XXX, "z": XXX }, "sizeTop": { "x": XXX, "y": XXX, "z": XXX }, "sizeOuter": { "x": XXX, "y": XXX, "z": XXX }, "materials": { "front": "XXX", "back": "XXX", "top": "XXX" }, "typearticlenumber": "XXX", "articlenumber": "XXX", "elements": [ etc. ...
The three values that are of importance are: "front", "back", "top". So ideally the table should look like this:
Thanks for the help!
Solved! Go to Solution.
After import the json file, you can click list-> Record-> Record(Material)s, then click "Into Table", click column "Name" column, then click Transform-> Pivot Columns.
The result will be like below;
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
After import the json file, you can click list-> Record-> Record(Material)s, then click "Into Table", click column "Name" column, then click Transform-> Pivot Columns.
The result will be like below;
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
98 | |
90 | |
84 | |
70 | |
67 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |