Alteryx Designer Desktop Discussions

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

Is it possible to pull the formula from the excel instead of the data in input tool

jasonshao
Meteoroid

For example, if the cell has "=1+1", I want Alteryx to pull "=1+1" instead of "2".

3 ANTWORTEN 3
Emmanuel_G
Pulsar

@jasonshao 

 

Find in attachement the way of doing that.

 

Did you want something like this ?

 

Emmanuel_G_0-1665587902054.png

 

 

Christina_H
Magnetar

See this thread: Solved: Alteryx Excel Import, Is there a way to bring thro... - Alteryx Community

Sounds like it's possible but not simple.

binuacs
Arcturus

@jasonshao If you want to extract the excel formula you need to parse the .zip version of your excel file The below post will give you an idea of how to do it

 

Re: comparing column headers and notes in header c... - Alteryx Community

 

Beschriftungen