0

I copy a csv file with a json-string column to the data flow.

enter image description here I want to flatten it by the json-string column, but the column is not recognized as a json format.

How do I convert it to json-format column, or do you have other ways to deal with it? Thank you

2
  • Hi @Qianru Song, JSON value contains {"key":"value"}. It seems that column named "Data" does not look to be in JSON format. Commented Jan 18, 2021 at 1:56
  • Hi Joseph, yes that is not json. Thank you Commented Jan 19, 2021 at 14:36

1 Answer 1

1

You could ref my answer here: https://stackoverflow.com/a/65770042/10549281

If you have any other concerns, please feel free to let me know.

HTH.

Sign up to request clarification or add additional context in comments.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.