converting Json data in qlik table format which is... - Qlik Community - 2131994

Skip to main content

Qlik.com | Qlik Help | Resources

Ask a Question

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.

Hi,

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.

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

[{"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":"<Not required>"},{"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":"<Not required>"},{"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}]}]}]

17 KB

1 Reply

Look into the function JsonGet()

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Scripting/StringFunction...

It takes two arguments - your json string, and the path to the desired value.

Bitmetric has a good post to review https://www.bitmetric.nl/blog/qlik-sense-json/

-ws