Checking For Blank Fields on Large Table

[Paddydd]

Hi All

I was wondering if someone could please help me ?

I have a large table, that is 2m lines long and 223 columns wide. I have been asked to run this through Alteryx and apply the following logic :-

If the field contains a 0 or a blank or is null then mark it with a 0

If it contains text then mark it with a 1.

Then I have to sum each field to find out how many times there is a value in each field. (Count all the 1s)

I dont want to have to set up 223 fields with either a Case Statement or If Then Else as I'd probably be an old man with a white beard by the time I finish.

Is there another way of doing this in an automated fashion.

Any help would be gratefully received.

Many thanks

Paddy

[messi007]

@Paddydd,

1- Below the fomula to update th value for all columns

2- Cross tab to get back to the source data

3- I don't understand the second part when you say "how many value on each field"

But what I did is I filtred the 0 (Updated value) and did the summarize on them:

Attached the workflow.

Hope this helps!

Regards

[Paddydd]

Is there any chance you could report your file ? When I try and download it, i'm told no file is there.

[atcodedog05]

Hi @Paddydd 

Refresh the page and try again might work 🙂

[dataguyW]

Multi-Row and Basic Sum version.  This assumes you know how many columns (as stated).  Because your datatypes were mixed vachar/double you just change the Multi-Column formula to All Types so you can click "Select All".  When you do the Summary Tool, select the first Column, hold shift,  and then select last column on to make it faster to select all columns.