Using If(len(trim during loading of a column

kschramm — Mon, 10 Aug 2015 18:00:26 GMT

Hi. Using QV, I am loading data from a QVD and have a scenario that I need to address. The Level9Y column is a char field. In the QVD, there are some cases where Level9Y is null but the percentage is not. I am trying to not place a value in the percentage9 column if Level9y is null. FYI..The len(trim approach seems to work best versus an isnull in other scripts that we have written.

I cannot find an example in the Qlik help that explains the parameters in detail for this scenario.

Thank you in advance.

LOAD Level1 AS HProperty,
EffectiveDate,
APPLYMAP('MAP_Yardi',Level9) AS Level9Y,
if(LEN(TRIM(Level9Y)) > 0,' ') Percentage9,

If have also tried:

if(LEN(TRIM(Level9Y)) > 0,Level9Y') Percentage9, and

if(LEN(TRIM(Level9Y)) > 0,'Percentage9 ') as Percentage9,

Re: Using If(len(trim during loading of a column

Anonymous — Mon, 10 Aug 2015 18:12:17 GMT

you are creating the field Level9Y and you Access it right away.

you Need to use a preceding load

load *,

if(LEN(TRIM(Level9Y)) > 0,' ') Percentage9;

load

Level1 AS HProperty,
EffectiveDate,
APPLYMAP('MAP_Yardi',Level9) AS Level9Y,

...

topic Re: Using If(len(trim during loading of a column in QlikView

Using If(len(trim during loading of a column

Re: Using If(len(trim during loading of a column