Mapping file workflow with formulas inside

[AG922]

Hello Everyone,

I am encountering a problem when trying to use a mapping file when creating an Alteryx workflow, which contains formulas from the working file, and I hope someone will be able to help me. I have a working file NTG.xlsx and from this file I need to match several fields based on a GL account number and according to ID. In the mapping file you can see that based on codes they are assigned to different account numbers, in which some codes are summed up or deducted from one another. For example, codes ET + TA + KASM + KOM + SVEN + DIEN all need to be added up for each ID and assigned code 509010 or several codes need to be added or deducted and put into GL account 510030. This needs to be done for every ID and as an example it should look like this for ID 16220:

 

First it should be GL acc, in CC should be left blank, then should go to ID, NS, Com is always 1364, then the calculated amounts.

If you have any solutions for this mapping, please do not hesitate:)

Kind regards
Akvile

[Prometheus]

@AG922 Take a look at this thread. It gives you a couple of different ways you can solve your problem. https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Formula-to-pull-the-value-from...