Excel data appearing as 00:00:00 while reading

[ayush_mishra]

I am reading data from an Excel file. A few columns have formula, instead of reading actual values from Excel cell, Alteryx is reading them as 00:00:00.

Column with Formula =IF(AT5>=AR5,"Y","N")

Both AT and AR are numeric column. And while reading from the file instead of getting Y or N, I am getting 00:00:00 in alteryx.

[OTrieger]

@ayush_mishra 

This could happen when the data was entered to the excel file and then the values were updated from the formulas, but the excel file itself was not open and saved. So let say Alteryx is writing data and then based on this data these fields are been updated. So if you will now connect this file to Alteryx before opening it and saving it, these values for the cells with formulas are still zero from Alteryx perspective. To get the values to reflect into the cells with the formulas you will need to open excel and save it, then you will see the values in Alteryx.

[ayush_mishra]

Hi @OTrieger If you meant to open the excel, save it, then run workflow. That's what I did and still seeing 00:00:00 instead of actual value "Y" or "N".

OR did you mean to save formulas as values?

[ayush_mishra · Accepted solution]

Hi @OTrieger FYI, I raised a ticket and alteryx support team asked me to change the data type of my column with formula. It was set to date and I changed it to General and it worked.