Reading Excel Files with cells having Div/0

I have an excel file that could potentially have Div/0 cells. The requirement is to throw an error if there are any such cells. In Alteryx, I see these are coming in as Null. Blanks cells are also represented by Nulls. Please advise if there is a way in designer to be able to identify Div/0?

Data Investigation

Accepted answers

sandeepmp

@Qiu I kind of used your idea and read the file as if there are no headers. Alteryx then read all the columns as text. I then used the dynamic rename tool to use the data in the first row as headers. Now I am able to capture div/0 cells. Thank You for your input!

All comments

Christine_Assaad

Hi @sandeepmp

Can you elaborate more on the use case? Can't you do this division in Alteryx and throw an error if the denominator is zero? TY!

Qiu

@sandeepmp

I hope there is another better way but based on test, we can change the column containing "Div/0" to a Text format. then the "Div/0" can be brought in.

0719-sandeepmp.yxzp

sandeepmp

@christine_assaad I am getting a file in a folder by an automated process. We don't want to replicate the calculation logic in Alteryx. Special processing is required in case the file contains div/0 cells.

@QiuSince the file is coming to a folder by an automated process, we will not have access to modify the columns to be text.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703