Issue with Filtering data dynamically from other SQL Input

[nkrishnakris]

Hi,

I have a scenario where I will be accessing table1, while processing the data I have to filter table1 data from table2 max process date. Is there a solution for this.

Table1 

ProductID, ProductItem, PurchaseDate

1,Bananna, 2018-01-01

2.Apple,2018-01-02

Table2

PurchaseDate

2018-01-01

When I running the workflow I have to take table2 data which is greater than 2018-01-01 (it should be only one record).

Thanks and Regards,

Krishna

[mbarone]

I'd make it easy on myself and just bring in both tables, use a Summarize tool to get the max date on table 2, and join it to table one on that date.

[nkrishnakris · Accepted solution]

Hi @mbarone ,

Thank for sharing your thoughts, I was able to overcome the issue by using the Append and Filter.

I Appended Table1 and Table2 (In table2 I was using max date) and Filter where Table1 Date column is greater than the Appended Table2 Date column. This fixed my problem.

Thanks and Regards,

Krishna  

[atcodedog05]

 Hi @nkrishnakris 

Happy to hear your problem is solved 🙂. Since you were able to solve your problem on your own you can mark your own response as solution. That way people get to know this post is solved.

Cheers and have a nice day!