1 Reply Latest reply: Mar 8, 2017 4:35 PM by Muñoz Héctor RSS

    Loading data with date range and where clause

    Ryan Brunet

      I'm trying to load data from an excel file with a where clause that include filtering by a field as well as within a certain date range.  The fields I'm using are 'neighbourhood' and 'billing_date' where billing_date is in the following timestamp format: 2010-08-01 00:00:00.000000 -04:00

       

      How might I do this in the load script where the neighbourhood matches a specific value such as 'Liberty Village' and I'm pulling in data where the  billing_date is less than today?  The file I have has transactions written for the rest of the year.