Apologies if this has come up earlier, I could not find it. I know it might be something very simple but for a novice like me, it looks complicated.
I want to compare rows of different data set and add a column in the second data set based on the comparison.
Data set 1 : Hourly rate
Data set 2 : Hours worked
Hourly rate changes multiple times in a month. We are required to calculate the amount based on the hours worked on a particular day.
Attaching the excel for your reference.
Data set 1: Hourly rate
Data set 2: Hours worked
Desired output:
Thanks for your time in advance.
Solved! Go to Solution.
Try the Multi-Row Formula tool and the Generate Rows tool. See attached workflow.
Also suggest... become familiar with the CReW macros, and use a macro like Expect Zero on the D output anchor of the Unique tool, to ensure accurate data.
Chris
Chris, Thanks a lot. It helped.
Sorry to bother, but where can I find CReW macros details.
regards
CReW macros:
On this page: http://www.chaosreignswithin.com/p/macros.html
Is the text:
Available for download at
http://Downloads.ChaosReignsWithin.com/Macros.zip
NOTE: You will require Alteryx 10.0 or later to use this macro pack.
From what I've seen, these macros are widely used by many in the Community, and by Alteryx.
Chris