topic Re: Null values in variable in QlikView

Null values in variable

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I'm getting null values stored in the variables. Please could anyone say what I did wrong in the script?

Attached my QVW file. Please help.

Thanks,

Siva.

Anil_Babu_Samineni — Mon, 14 Aug 2017 16:25:44 GMT

Can you make this table in inline with few rows, Will test the same

VarCustomer:

LOAD Distinct Customer as VarCustomer,

Originformat as IN,

Destinationformat as OUT

Resident Fields2;

Anonymous — Mon, 14 Aug 2017 17:25:22 GMT

Please find the below data,

LOAD * INLINE [

Customer, Origin Format, Destination Format

Crago, HR, X12

Hapg, HR, X12

Mrsk, CIDX, GIX

Addnt, HR, EDIFACT

];

jpitfield — Mon, 14 Aug 2017 19:09:45 GMT

your issue may be here because of empty spaces :

Fields2:

LOAD *,

if(Len(BusinessInputFieldFlag)=0,'N',BusinessInputFieldFlag) as BIFF,

if(Len(BusinessOutputFieldFlag)=0,'N',BusinessOutputFieldFlag) as BOFF

Resident Customer;

Try:

Fields2:

LOAD *,

if(Len(Trim(BusinessInputFieldFlag))=0,'N',BusinessInputFieldFlag) as BIFF,

if(Len(Trim(BusinessOutputFieldFlag))=0,'N',BusinessOutputFieldFlag) as BOFF

Resident Customer;

This will return 0 for nulls and empty spaces

HTH Jim

Anil_Babu_Samineni — Tue, 15 Aug 2017 00:09:45 GMT

Looks good until unless you provide real data.