Forum Discussion

Snowy34's avatar
Snowy34
Helper III
6 years ago
Solved

Exclude dates table Filter

Good day all,    Here we are back with a new issue, what I have is two data tables, the first table holds my records of the deliveries from order date to delivered date. What I will like to add a c...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    6 years ago

    Hi,

    Ensure that in the WH column of Table2, there are only unique values.  Also, in the Relatioinshop window, select Many to One and Singe.

Snowy34's avatar
Snowy34
Helper III
6 years ago

Hi, Ashish_Mathur  again,

 

But if I do that most of my data is now gone apart from one day... across all the warehouses

 

 

 

 

Ashish_Mathur's avatar
Ashish_Mathur
Super User
6 years ago

Hi,

I cannot understand what you are trying to tell me.

  • Snowy34's avatar
    Snowy34
    Helper III
    6 years ago

    Ashish_Mathur 

     

    Basically I need to get a number of days it has taken to deliver an item but excluding weekends and public holidays, this would be quite easy to do if I didn't have warehouses that are in different states. Meaning what is a public holiday in Wearhouse 666 not a public holiday in Wearhouse 222.

     

    I created a table that holds all public holidays for each Wearhouse and I was hoping I could use that when figuring out my days taken to deliver an order.

     

    I hope this clears out what my issue is.

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      6 years ago

      Hi,

      What problem do you run into when you impleent my suggested solution.  Please be specific.

      • Snowy34's avatar
        Snowy34
        Helper III
        6 years ago

        Good day Ashish_Mathur 

         

        Thank you for your help, in the end, I got it working using your approach 🙂 

         

        Regards

        Snowy