Dear all,
Can somebody help me with parsing the cmplex nested JSON
Yes.
Now perhaps you can post a sample of the json you are having an issue with?
There is a JSON Parse Tool: https://help.alteryx.com/current/en/designer/tools/developer/json-parse-tool.html##. If you still need further help, please post a sample as mentioned above.