Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be this
left join (DATA)
LOAD
[Document_title] ,
if(Approval_Baseline_Date<>'empty' and Approval_forecast_date<>'empty', [Approval_forecast_date]-[Approval_Baseline_Date],'empty') as ApprovalForecastVsBaseline
Resident DATA;
May be this
left join (DATA)
LOAD
[Document_title] ,
if(Approval_Baseline_Date<>'empty' and Approval_forecast_date<>'empty', [Approval_forecast_date]-[Approval_Baseline_Date],'empty') as ApprovalForecastVsBaseline
Resident DATA;
it works,
Thanks Antonio !