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.
May not be an effective solution, but can you just add a ' ' blank space?
How about creating a union with just one field with the name of the column and merging with rest of the flow?