Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

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.

binu_acs
21 - Polaris

@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
Top Solution Authors