12 Replies Latest reply: Jan 5, 2016 12:43 PM by Tamil Nagaraj RSS

    Problem with date in loading script

    Eduard Cabanas Gili

      Hi,

       

      I did this script to load data from MySQL and I have a problem. The table has records from part of 2015 and 2016, but I only want to load the 2016 records.

       

      The field created_at is a timestamp and did not do the filter that I desire:

       

      SalesLine:

      LOAD created_at as CreatedatSalesLine,

      order_id,

      'PV' & right('00000000'&order_id,8) as SalesId,

      if(IsNull(product_id),code,product_id)as ItemId,

      //code as ItemId,

      price,

      gift,

      quantity_in_order,

      quantity_purchased,

      quantity_delivered,

      1+(ApplyMap('Tax_Item_Map',product_id)/100)as Tax,

      (price/1+(ApplyMap('Tax_Item_Map',product_id)/100))as Import_Brut,

      ApplyMap('Date_Invoice_Map',order_id)as Date_Invoice;

      SQL SELECT created_at ,order_id, product_id ,price, gift,quantity_in_order,quantity_purchased,quantity_delivered,code FROM ulaoffice.NS_order_lines

       

      where floor(created_at)>42369;

       

      Many thank's for your help

       

      Eduard