Good day, I've been trying to read through the community posts but I was not able to find a similar question.
I am trying to input an excel file into Alteryx.
In that Excel file, most of the cells are a result of Vlookups from another excel tab or workbook.
For example, a column called "Names" is sourced from another sheet via Vlookup.
When I input the sheet into Alteryx, the program reads the columns in a different ways, not the results of those formula.
For example, the "Names" columns show as 00:00:00 when imported into Alteryx.
What shall I do to make Alteryx read the intended cell values?
Thanks for your time!
@vonnjovi
try to save excel file without formulas as this issue is due to bringing lookup values from different sheet.