Excel data appearing as 00:00:00 while reading

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.

Workflow

Input

Preparation

Data Investigation

Accepted answers

ayush_mishra

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.

Capture.PNG

All comments

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

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.

Capture.PNG

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

RithiS 280