https://community.qlik.com/t5/App-Development/converting-Json-data-in-qlik-table-format-which-is-currently/m-p/2133523#M92124 <P>Look into the function JsonGet()</P> <P><A href="https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Scripting/StringFunctions/JsonGet.htm?_ga=2.115384515.49683161.1698660090-1336698350.1692026537" target="_blank">https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Scripting/StringFunctions/JsonGet.htm?_ga=2.115384515.49683161.1698660090-1336698350.1692026537</A></P> <P>It takes two arguments - your json string, and the path to the desired value.</P> <P>Bitmetric has a good post to review&nbsp;<A href="https://www.bitmetric.nl/blog/qlik-sense-json/" target="_blank">https://www.bitmetric.nl/blog/qlik-sense-json/</A></P> <P>-ws</P> Tue, 31 Oct 2023 21:39:39 GMT WaltShpuntoff 2023-10-31T21:39:39Z https://community.qlik.com/t5/App-Development/converting-Json-data-in-qlik-table-format-which-is-currently/m-p/2131994#M92013 <P><SPAN>I have a CSV file and it contains Json data format and this data i would like to put in Qlik tables which i am unable to do it.</SPAN></P> <P>&nbsp;</P> <P>Hi,</P> <P><SPAN>I have a Hex encoded Json data format coming inside a column in PostGres Table and this data i would like to fetch in Qlik, which i am unable to do it.</SPAN></P> <P><LI-WRAPPER></LI-WRAPPER></P> <P>Below is the example for it: Below data is present in one cell and in below data we have have root level data , root 0 and root 1. Please help me with solutions</P> <TABLE width="408"> <TBODY> <TR> <TD width="408">[{"name":"Planning pack","uniquePhaseIdentifire":"Planningpack","stt":"7","internalDeadline":"07/10/2023","externalDeadline":null,"isPhaseCompleted":"false","phaseFields":[{"name":"PlanningpackSTT","value":7},{"name":"PlanningpackInternalDeadline","value":"07/10/2023"},{"name":"PlanningpackExternalDeadline","value":""},{"name":"PlanningpackPhaseNotes","value":null},{"name":"PlanningpackMytimeCodePart1","value":"FGHJ17"},{"name":"PlanningpackMytimeCodePart2","value":null},{"name":"PlanningpackMytimeCodePart3","value":null}],"steps":[{"name":"AwaitInstructions","fields":[{"name":"AwaitInstructionsid","value":1},{"name":"AwaitInstructionsstepName","value":"Await instructions"},{"name":"AwaitInstructionscamName","value":"AwaitInstructions"},{"name":"AwaitInstructionsSTT","value":0.25},{"name":"AwaitInstructionsStepStartDate","value":null},{"name":"AwaitInstructionsDeadline","value":null},{"name":"AwaitInstructionsActual","value":null},{"name":"AwaitInstructionsUser","value":"peter-kilpatrick"},{"name":"AwaitInstructionsdisabled","value":false},{"name":"AwaitInstructionsisSSDGreaterThanSDL","value":false},{"name":"AwaitInstructionstaskCompletedBy","value":""},{"name":"AwaitInstructionstaskCompleteDate","value":""},{"name":"AwaitInstructionsisSSDEqual","value":false},{"name":"AwaitInstructionsisSDLEqual","value":false},{"name":"AwaitInstructionsisSSDAndSDLEqual","value":false},{"name":"AwaitInstructionsstepDateSeqChecker","value":false},{"name":"AwaitInstructionsisValid","value":true}]},{"name":"Processing","fields":[{"name":"Processingid","value":2},{"name":"ProcessingstepName","value":"Processing"},{"name":"ProcessingcamName","value":"Processing"},{"name":"ProcessingSTT","value":4.5},{"name":"ProcessingStepStartDate","value":null},{"name":"ProcessingDeadline","value":"05/10/2023"},{"name":"ProcessingActual","value":null},{"name":"ProcessingUser","value":"peter-kilpatrick"},{"name":"Processingdisabled","value":false},{"name":"ProcessingisValid","value":true},{"name":"ProcessingisSSDGreaterThanSDL","value":false},{"name":"ProcessingtaskCompletedBy","value":""},{"name":"ProcessingtaskCompleteDate","value":""},{"name":"ProcessingisSSDEqual","value":false},{"name":"ProcessingisSDLEqual","value":false},{"name":"ProcessingisSSDAndSDLEqual","value":false},{"name":"ProcessingstepDateSeqChecker","value":false}]},{"name":"Check","fields":[{"name":"Checkid","value":3},{"name":"CheckstepName","value":"Check"},{"name":"CheckcamName","value":"Check"},{"name":"CheckSTT","value":2.25},{"name":"CheckStepStartDate","value":null},{"name":"CheckDeadline","value":null},{"name":"CheckActual","value":null},{"name":"CheckUser","value":"&lt;Not required&gt;"},{"name":"Checkdisabled","value":false},{"name":"CheckisValid","value":true},{"name":"CheckisSSDGreaterThanSDL","value":false},{"name":"ChecktaskCompletedBy","value":""},{"name":"ChecktaskCompleteDate","value":""},{"name":"CheckisSSDEqual","value":false},{"name":"CheckisSDLEqual","value":false},{"name":"CheckisSSDAndSDLEqual","value":false},{"name":"CheckstepDateSeqChecker","value":false}]},{"name":"CompetencyReview","fields":[{"name":"CompetencyReviewid","value":4},{"name":"CompetencyReviewstepName","value":"Competency review"},{"name":"CompetencyReviewcamName","value":"CompetencyReview"},{"name":"CompetencyReviewSTT","value":null},{"name":"CompetencyReviewStepStartDate","value":null},{"name":"CompetencyReviewDeadline","value":null},{"name":"CompetencyReviewActual","value":null},{"name":"CompetencyReviewUser","value":"&lt;Not required&gt;"},{"name":"CompetencyReviewdisabled","value":false},{"name":"CompetencyReviewisValid","value":true},{"name":"CompetencyReviewisSSDGreaterThanSDL","value":false},{"name":"CompetencyReviewtaskCompletedBy","value":""},{"name":"CompetencyReviewtaskCompleteDate","value":""},{"name":"CompetencyReviewisSSDEqual","value":false},{"name":"CompetencyReviewisSDLEqual","value":false},{"name":"CompetencyReviewisSSDAndSDLEqual","value":false},{"name":"CompetencyReviewstepDateSeqChecker","value":false}]},{"name":"Release","fields":[{"name":"Releaseid","value":5},{"name":"ReleasestepName","value":"Release"},{"name":"ReleasecamName","value":"Release"},{"name":"ReleaseSTT","value":null},{"name":"ReleaseStepStartDate","value":null},{"name":"ReleaseDeadline","value":"07/10/2023"},{"name":"ReleaseActual","value":null},{"name":"ReleaseUser","value":"peter-kilpatrick"},{"name":"Releasedisabled","value":false},{"name":"ReleaseisSSDGreaterThanSDL","value":false},{"name":"ReleasetaskCompletedBy","value":""},{"name":"ReleasetaskCompleteDate","value":""},{"name":"ReleaseisSSDEqual","value":false},{"name":"ReleaseisSDLEqual","value":false},{"name":"ReleaseisSSDAndSDLEqual","value":false},{"name":"ReleasestepDateSeqChecker","value":false},{"name":"ReleaseisValid","value":true}]}]}]</TD> </TR> </TBODY> </TABLE> Thu, 26 Oct 2023 09:49:34 GMT https://community.qlik.com/t5/App-Development/converting-Json-data-in-qlik-table-format-which-is-currently/m-p/2131994#M92013 Monali-waghavkar 2023-10-26T09:49:34Z https://community.qlik.com/t5/App-Development/converting-Json-data-in-qlik-table-format-which-is-currently/m-p/2133523#M92124 <P>Look into the function JsonGet()</P> <P><A href="https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Scripting/StringFunctions/JsonGet.htm?_ga=2.115384515.49683161.1698660090-1336698350.1692026537" target="_blank">https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Scripting/StringFunctions/JsonGet.htm?_ga=2.115384515.49683161.1698660090-1336698350.1692026537</A></P> <P>It takes two arguments - your json string, and the path to the desired value.</P> <P>Bitmetric has a good post to review&nbsp;<A href="https://www.bitmetric.nl/blog/qlik-sense-json/" target="_blank">https://www.bitmetric.nl/blog/qlik-sense-json/</A></P> <P>-ws</P> Tue, 31 Oct 2023 21:39:39 GMT https://community.qlik.com/t5/App-Development/converting-Json-data-in-qlik-table-format-which-is-currently/m-p/2133523#M92124 WaltShpuntoff 2023-10-31T21:39:39Z