Alteryx Designer Desktop Discussions

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

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

jasonshao
6 - Meteoroid

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

3 REPLIES 3
Emmanuel_G
13 - Pulsar

@jasonshao 

 

Find in attachement the way of doing that.

 

Did you want something like this ?

 

Emmanuel_G_0-1665587902054.png

 

 

Christina_H
14 - 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
20 - 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

 

Labels