Create Column with sum of NULL values in rows

[ROUD89]

Hi all,

I wan to omit rows that have more than X NULL values. In R I can simply do this, however I have not found the functionality for this in Alteryx. How can I do a RowSum(is.na(dataframe)) in Alteryx? Would be greate to create a new column that sums the NA's over the rows.

thanks for helping out.

[SeanAdams · Accepted solution]

Hey @ROUD89

This is very quick and easy - I've mocked it up in the attached flow.

Summary:

- add a row ID

- transpose columns into rows

- filter out the non-nulls

- Count by record ID

Hopefully this solves the problem (less simple than a quick R formula) - if so, would you mind marking as "Solved"?  if there are still questions or worries - feel free to add to the workflow and reply.

Have a good weekend

Sean