Hi Alteryx team,
I have an input file with a lot of formula such as sum, equals, percentage multiply to amount, etc. I want the file to be converted to another format (say, .dat file), but before that, I want all the formulas embedded in my file (or to a specific sheet) to be removed before converting to another file format. Is Alteryx has the ability to paste values or remove formulas in the input file? I mean All formulas inside the file or sheet. Thank you in advance.
Solved! Go to Solution.
Hi @PassION_es
Always excel will remove the formulas and consider the values only.
Please find the example below.
Input file Excel:
Alteryx:
Hope this answers your question.
Many thanks
Shanker V
hi @ShankerV , I am trying to convert an excel input file into .dat file format. However, when there is a formula inside the excel, it won't generate or transfer the correct data into the .dat file. I am aware that there's no need to convert formulas into values as Alteryx read it as values. The issue is that when I am not manually remove the formulas in excel before running the workflow to convert file to a different format (.dat file), it will generate wrong data into the .dat file.
@PassION_es It seems to be fine in this simple example that I have. Is the file format that you are reading in a .xlsx or something else?
Welcome anytime, happy that my ideology helped you.
Feel free to make use of the community page anytime.
Many thanks
Shanker V