Issue While using JSON

[geeksqaud]

Hi Friends,

I'm using Alteryx to pull data from a JSON source with "comments" and "comments required" as one of the fields.

I'm extracting data for the last 10 days and creating a new field by combining "comments" and "comments required."

However, if either field is empty, downstream processes are failing as there is no metadata column present in the file.

Issue: When there's no data in "comments" or "comments required," the workflow breaks downstream.

Request for Assistance: Need help handling empty values in the concatenated field to avoid downstream failures.

Looking for a simple solution in Alteryx.

[CoG]

May not be an effective solution, but can you just add a ' ' blank space?

[geeksqaud]

How about creating a union with just one field with the name of the column and merging with rest of the flow?