'empty' missing

victor_greffet — Mon, 06 Nov 2017 10:18:04 GMT

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

Re: 'empty' missing

antoniotiman — Mon, 06 Nov 2017 10:29:37 GMT

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;

Re: 'empty' missing

victor_greffet — Mon, 06 Nov 2017 15:10:32 GMT

it works,

Thanks Antonio !

topic Re: 'empty' missing in App Development

'empty' missing

Re: 'empty' missing

Re: 'empty' missing