Hi all,
I have two inputs.
Input 1 has headers - Account, Period, From, To.
Input 2 has headers - Account, Date. Period is what I want the workflow to identify. Input 2 looks like it has duplicates but its not because $ posted will be different for each date, so I cannot delete duplicates
Output:
Input 2 has entries posted for each account by date. I want to find from input 1, in which period a particular entry in input 2 belongs to. For example: 789101, entry posted on 07/31/2016 falls into period 1 based on the date range in input 1. 08/01/2016 falls into the period 2 based on the date range in input 1., so on and so forth. If data falls outside the range, it should be labelled as "Outside the period".
Below is my desired output
Attaching the files, and the workflow I tried. I missing something in my workflow. Not sure what it is.
Thanks for looking into this.
@binuacs I am unable to open the workflow.
@dsevilimedu attaching the workflow again. Let me know if you face any issues