Forum Discussion
Solved
Stuck on Date merge
Hi all, I’m running into an issue that I hope that you can help me with. I am trying to merge two tables based on four conditions: Date, Customer Price Group, SSO and Item Category. Both tables h...
Well I found a work around it seems.
I decided to join on just the categories and bring over the Start and End dates of the backconditions to the sales table that way. Conditional column on those dates and posting dates and voila I have what I need. Not a pretty solution, but I guess it will work for now.
Thanks for the input.
Well I found a work around it seems.
I decided to join on just the categories and bring over the Start and End dates of the backconditions to the sales table that way. Conditional column on those dates and posting dates and voila I have what I need. Not a pretty solution, but I guess it will work for now.
Thanks for the input.
No problem.
Glad you have a working solution. 👍