topic Re: concat problem in script in QlikView

concat problem in script

Anonymous — Mon, 18 Nov 2013 10:56:21 GMT

Hi Geniuses,

When I am concatenating 20 with one column it gave me wrong result. Below is the script

LOAD

'20' & Right([Fiscal Year],2) AS FY ,

[Fiscal Year]

FROM

[..\..\QVD_DATA\ETG\S_E_Bookings.qvd]

(qvd)

where Fiscal Year is FY10, FY11,FY12,FY13

The desired result is 2010,2011,2012,2013

Result which I am Getting 20,2010,2011,2012,2013

I want to remove that unwanted 20

Thanks in advance

swuehl — Mon, 18 Nov 2013 11:03:25 GMT

What is the Fiscal Year value for the record you get 20 in FY (just select 20 in FY and look at the other field)?

I assume it's NULL.

You can check for NULL like

LOAD

if(len(trim([Fiscal Year])), '20' & Right([Fiscal Year],2) ) AS FY ,

[Fiscal Year]

FROM

[..\..\QVD_DATA\ETG\S_E_Bookings.qvd]

(qvd)

Clever_Anjos — Mon, 18 Nov 2013 11:06:03 GMT

It seems you have one (or more) record with NULL into [Fiscal Year] field

Mon, 18 Nov 2013 11:13:50 GMT

Hi,

Check out the Solution given in the below file

Nothing Changes required.

hope it helps you.

Regards,

Ravikant

Anonymous — Mon, 18 Nov 2013 11:25:40 GMT

Thanks a lot swehl, it worked