Importing cells as text strings and not as formulas
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
vonnjovi
5 - Atom
‎08-09-2024
09:20 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
Labels:
- Labels:
- Designer Cloud
- Input
- Text Mining
- Transformation
1 REPLY 1
Raj
16 - Nebula
‎08-09-2024
09:29 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@vonnjovi
try to save excel file without formulas as this issue is due to bringing lookup values from different sheet.
