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?
Solved! Go to Solution.
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!
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.
@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.
@Qiu Since the file is coming to a folder by an automated process, we will not have access to modify the columns to be text.
@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!