I Would like some advice being new to ETL & programming. I want to know what function is best to use to get the following outcome for NLG on a data set.
I would like to list a set of variables and their associated values in an NLG output through the 'Formula' tool in Alteryx. Where there is no value I want to substitute the blank space for 'no record'.
I've taken a look at replicating this and would recommend a series of pivots to prepare the data. This splits each value to tag it's component parts (new field name and units), builds the string per field then concatenates by recordID.
You can see this now dynamically handles 'no record' status in your raw data:
I've attached the workflow for you to test out.
If this has resolved your problem, please mark it as solved - otherwise please let me know!
Alternatives or tidier execution of IF statements.yxmd