Hi,
I am new to Alteryx. While I am able to build simple workflows, I am stuck on a complex situation using the Multi-Field tool.
What I have is an employee database with salary, and building for a Year 1 (ex. 2024) and Year 2 (ex. 2025), with each month in a column. Each of this monthly columns has an employee salary.
Year 1 and Year 2 will change every year, so I already have build something that creates those monthly columns. Workforce planning.
What I try to achieve is to tell Alteryx to increase (Merit) the monthly salary April of Year 1 by x% and the following month to keep that new amount (May to December). Then increase the April of Year 2 by Y% and keep that new salary in each following months.
Example for Feb and March 2024 we have the current salaries, but as of April 2024 until March 2025 we need to apply current salary*1%, and also as of April 2025, add a new 3% increase.
The Multi Field tool seems to be the only way to keep this dynamic.
What I could come up with as a beginner is only the following, but lacking too much knowledge. I also have attached an example excel of how it should look like as an output and input on each tab.
IF StartsWith([_CurrentFieldName_], 'Salaries 202') != 0
THEN [_CurrentField_] + [_CurrentField_]*[Merit Y2]/100
ENDIF
Would someone be able to help me out?
Many thanks
Kind regards,
J.
