2 Replies Latest reply: Nov 6, 2017 10:10 AM by Victor GREFFET RSS

    'empty' missing

    Victor GREFFET

      Hi community,

       

      In my app, I have to load data from 2 differents Excel files. In order to join data, I did a left join using 'Document title' as "key" :

       

      The initial script is :

       

      DATA:

      LOAD

      if(len(trim([Document title]))=0,'empty',[Document title]) as [Document_title] ,

      if(len(trim([Approval forecast date]))=0,'empty',date([Approval forecast date])) as [Approval_forecast_date]

      FROM [lib://SD/Excel.xlsm]

       

      left join (DATA)

      LOAD

      if(len(trim([Document title]))=0,'empty',[Document title]) as [Document_title] ,

      if(len(trim([Approval Baseline Date]))=0,'empty',date([Approval Baseline Date])) as [Approval_Baseline_Date]

      FROM [lib://SD/Excel2.xlsm];

       

      left join (DATA)

      LOAD

      if(len(trim([Document_title]))=0,'empty',[Document_title]) as [Document_title] ,

      if(Approval_Baseline_Date<>'empty' and Approval_forecast_date<>'empty', [Approval_forecast_date]-[Approval_Baseline_Date],'empty') as ApprovalForecastVsBaseline

      Resident DATA;

       

      And when I store DATA into DATA.csv, I realize that there isn't 'empty', just blank in concerned cells...

       

      Do you have an idea ?

       

      Thank you