Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
S
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)
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)
It seems you have one (or more) record with NULL into [Fiscal Year] field
Hi,
Check out the Solution given in the below file
Nothing Changes required.
hope it helps you.
Regards,
Ravikant
Thanks a lot swehl, it worked