Hello Everyone, I have a data which looks like this NameAgeCountryPay1Pay2Pay3Pay4Pay5Pay6Pay7Jacob23UK4367.4734685.263598.761234.589845.674756.8754635.67William31USA87458.677647.76356276.8773846.568728.7687348.7887248.78Kumar27India7246.64 93748.8723674.8745984.8783748.7723763.8Mazood24UAE6728.7825753.9834875.98 87348.9823672.98236724.9 I want calculate a new set of fields using a mapping sheet Standard NameClient DataCandidateNameAgeAgeNationCountrySalary1Pay1+Pay4+Pay5Salary2Pay2+Pay6Salary3Pay3Salary4Pay7 I am trying to create an Alteryx app which will calculate the Salary fields from the mapping sheet and the combination of Pay fields might change from case to case, and then I have to use these Salary fields for further calculation. So could you please help me to create a workflow which reads the combination from the mapping sheet and then dynamically calculate the Salary fields? Thanks in Advance!

Dynamic Field update using mapping file

Hello Everyone,

I have a data which looks like this

Name	Age	Country	Pay1	Pay2	Pay3	Pay4	Pay5	Pay6	Pay7
Jacob	23	UK	4367.47	34685.26	3598.76	1234.58	9845.67	4756.87	54635.67
William	31	USA	87458.67	7647.76	356276.87	73846.56	8728.76	87348.78	87248.78
Kumar	27	India	7246.64		93748.87	23674.87	45984.87	83748.77	23763.8
Mazood	24	UAE	6728.78	25753.98	34875.98		87348.98	23672.98	236724.9

I want calculate a new set of fields using a mapping sheet

Standard Name	Client Data
Candidate	Name
Age	Age
Nation	Country
Salary1	Pay1+Pay4+Pay5
Salary2	Pay2+Pay6
Salary3	Pay3
Salary4	Pay7

I am trying to create an Alteryx app which will calculate the Salary fields from the mapping sheet and the combination of Pay fields might change from case to case, and then I have to use these Salary fields for further calculation.

So could you please help me to create a workflow which reads the combination from the mapping sheet and then dynamically calculate the Salary fields?

Thanks in Advance!

Datasets

Custom Tools

Apps

Dynamic Processing

Accepted answers

danilang

Hi @hanz_e

This should get you started

Split your mapping table into 2. The first one has the field rename info. Just add new records to this to map new client fields to the standard ones. This mapping table is used by a Dynamic Rename tool to standardize the field names.

The second table contains formulas. These need to be in the same format as if you entered them in a formula tool, i.e. [Pay1]+[Pay4]+[Pay5]. These are used in the Dynamic Replace tool which is set up to act in formula mode. It evaluates each of the formulas using the data in each of the rows to give you the results