Getting the excel formulas as string

[BarunDas]

Hello,

Can anyone help me to extract the excel formulas as a string output.

Example: An Excel cell has the below formula:

=IF($A15="","",Reference!$G$15)

and the result is: US

How can I get the formula as output of Alteryx workflow that is

Output:

IF($A15="","",Reference!$G$15)

Please help.... 

[caltang]

You need to upload your "Reference" tab data as a mapping file (separate excel) into Alteryx, then use the Join Tool to get that figure.

Please be aware of the Join nature - if it's a many-to-many join, then make sure you know your keys well to join!

[binuacs]

@BarunDas To extract the Excel formula from the Excel you need to open the .xlsx as a zip file and then parse the various XML files within, you can find out all sorts of secrets. The below post might be helpful for your use case

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/comparing-column-headers-and-n...

[BarunDas]

Thanks @binuacs

Can you please let me know the configuration of tools used. Actually I am not able to download the attached file, is there any other way by which you can share the configuration of each tool?

Thanks again....

[binuacs]

@BarunDas what is the error you are getting when trying to download the workflow?

[BarunDas]

@binuacs

Thanks for your response.

Actually I do not have Alteryx in my personal system and I can't get or download anything in my office system.

[binuacs]

@BarunDas There are lots of steps you need to follow for this workflow, it is difficult to put all the tool and mention the settings in here