1 Reply Latest reply on May 11, 2018 11:17 AM by suman kumar

    Excluding Public holidays

    Krishna Dudhela

      Hi,

       

      Can anyone please tell me as how to exclude public holidays from the data?

       

      I have US public holiday .xlsx file and my data is in the ms sql server.

      How to connect these two?

       

      I tried using custom sql query, but it throws error.

       

       

      Please help.

       

       

      Thanks.

        • 1. Re: Excluding Public holidays
          suman kumar

          Hi

           

          First you'll have to join both table with any column then you can exclude public holiday.

          and for join, there should be one column column in both table.

           

          or

          you can write query like this:-

          suppose public holiday is on 1st January.

          if {Date] from SQL Server is equal to 1st January then public holidays

          .

          .

          .

          etc then you can filter out all public holidays.

           

          Thanks

          Suman