Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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
16 - Nebula

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

Labels