Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Importing cells as text strings and not as formulas

vonnjovi
5 - Atom

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!

1 REPLY 1
Raj
15 - Aurora

@vonnjovi 
try to save excel file without formulas as this issue is due to bringing lookup values from different sheet.

Labels