Load Data from a MySql Json field returns a raw field

[GillBech]

Hi everyone

I load a json field
in phpmyadmin, the field is shown ad a Json  :

{
"email": "xxxxxxxxx@xxx.xx",
etc.....

}

but after loading, the field looks like rawdata  see picture

I would just need first to get the data from MySql a a regular json 

Any clue ?
Thanks

[jftalmeida]

Hello Gillbech,

I also have this situation mapped to a customer, but as a workaround, you can apply an SQL command:

REPLACE(Field, '','') as Field 

This way the Qlik connector will extract correctly with its respective content.

Hope I helped you!

[Chanty4u]

Or try this 

my_table:

LOAD

  JSON(json_field) as my_json_field

FROM

  my_database.my_table;