JSON_EXTRACT in MySQL: Any Similar function Available in Qlikview / sense

[muniyandi]

Hi Team,

i want to know  JSON_EXTRACT function (in MySQL) or Similar function available in Qlikview / sense ?.

i had tried subfield function . but my data are semi structured , if any other option is there ? pls suggests me.

MySQL :: MySQL 8.0 Reference Manual :: 12.16.3 Functions That Search JSON Values

Thanks,

Muni

[balabhaskarqlik]

May be these links can:

https://community.qlik.com/thread/280397

https://community.qlik.com/docs/DOC-16915

https://community.qlik.com/docs/DOC-3129

https://docs.microsoft.com/en-us/sql/t-sql/functions/json-value-transact-sql?view=sql-server-2017

[muniyandi]

Hi Bala,

Thanks for your reply,

my table column are json  datatype.

[Oleg_Troyansky]

Have you found any solutions for this problem? I am having the same issue and am looking for working solutions with JSON_EXTRACT. Please let me know if you found something!