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,

Could you share a sample data? It will help us to give the solution 🙂

Regards

[atcodedog05]

Hi @Paddydd 

Can you provide sample input and expected output. So that we can get a better understanding 🙂

[john_watkins]

I would check into the Multi-Field Formula tool in the Preparation tools.   You can write the formula once and have it apply to many columns.

[Paddydd]

Here is a sample of the data. I've populated it with a figure but some fields are 0 and some Blank.

Does this help ?

[atcodedog05]

Hi @Paddydd 

What is the expected output?

[OllieClarke]

Hi @Paddydd 

Like the others said, if you can give us an example output, that would help. However, taking a punt, this workflow will give you a list of columns and whether those columns contain a 0 or blank as a boolean field:

[Paddydd]

Hi AtCodeDog05

A count of every field where the cell <> 0 or <> Blank or Is Not Null

[atcodedog05]

Hi @Paddydd 

Here is how you can do it for rows. Let me check for columns.

Workflow:

Hope this helps : )

[atcodedog05]

Hi @Paddydd 

Workflow for columns. If you tell the exact format we can try to acheive that.

Hope this helps : )