6 Replies Latest reply: Nov 28, 2014 12:00 PM by MICHEL MENTRIER RSS

    create a field calculated from 2 different tables

    MICHEL MENTRIER


      Hi,

      I have 2 tables loaded from excel & would like to calculate in the loading script an aggregated field that I could use as a dimension or expression when designing graphs.

       

      file1:
      LOAD [Sales Order] as Order,
          
      requested_date
      FROM
      [C:\Users\Documents\file1.xlsx]
      (
      ooxml, embedded labels, table is Sheet1); 

       

        

      file12
      LOAD [Sales Order] as Order,
          
      shipment_date
      FROM
      [C:\Users\Documents\file2.xlsx]
      (
      ooxml, embedded labels, table is Sheet1); 

       

      & field to add:

      networkdays (requested_date,shipment_date)-1 as on_time

       

      anyone could help me?

      thank you