Hello Everyone, I am trying to find a solution to below situation where I need an output based on merging 2 tables and applying some condition as below: Table1: IDsSegmentStart DateEnd DateAYellow1/1/202012/31/2020ARed6/1/201912/31/2019BBlue5/1/201812/31/2018 Table2: IDDateClaimsA8/1/201913A6/1/2020145B1/1/201412 Final Output I want: IDsSegmentClaimsAYellow145ARed13B 12 So basically the problem is like this: * I need an output which would tell me that for all IDs in Table 2 how many claims were falling in between the dates (Start Date and End Date) in Table 1 and then append their Segment from Table 1 * So, from the above tables for ID "B" since the "Date" in Table 2 is outside the range given for B in Table 1, therefore, it should display a blank in the "segment" column for B * Table 2 is my parent table i.e. I want data for all the IDs in Table 2 and if any ID is present in Table 1 and not in Table 2 then we can ignore that Hope I am able to explain this. What should be the best way to handle such things in Alteryx? Thanks in advance!

Joining Two Tables and applying where conditions

Hello Everyone,

I am trying to find a solution to below situation where I need an output based on merging 2 tables and applying some condition as below:

Table1:

Table2:

Final Output I want:

So basically the problem is like this:

I need an output which would tell me that for all IDs in Table 2 how many claims were falling in between the dates (Start Date and End Date) in Table 1 and then append their Segment from Table 1
So, from the above tables for ID "B" since the "Date" in Table 2 is outside the range given for B in Table 1, therefore, it should display a blank in the "segment" column for B
Table 2 is my parent table i.e. I want data for all the IDs in Table 2 and if any ID is present in Table 1 and not in Table 2 then we can ignore that