topic Create a new field from 2 fields in the load scrip with the data limited? in QlikView

Create a new field from 2 fields in the load scrip with the data limited?

hopkinsc — Thu, 03 Mar 2011 13:00:46 GMT

I want to create a new field in my script from 2 other fields but i also want to limit the data .

i.e.

DealNumber

DealName

I want to combine these 2 fields which is easy enough:

DealNumber & '-' & DealName AS [Deal Description],

I only want it to show DealNumber >=200050 and DealNumber <=200020 or DealNumber =900000 and call it [Meal Deals]

Can anyone please tell me how i would write this into the script?

Thanks

volcore79 — Thu, 03 Mar 2011 15:57:14 GMT

Could you send an example file ?

Thu, 03 Mar 2011 16:06:01 GMT

You can add an IF statement while generating the new column [Deal Description]

IF((DealNumber>=200050 and DealNumber<=200020) OR DealNumber=900000,DealNumber & '-' & DealName) as [Deal Description]

Hope this healps.

bismart — Thu, 03 Mar 2011 16:13:24 GMT

Think your selection criteria is wrong...

DealNumber cannot be >= 200050 and <= 200020

your code : DealNumber>=200050 and DealNumber<=200020 OR DealNumber=900000

Otherwise

Load

DealNumber & '-' DealName as [Deal Description]

from Tablename

where

DealNumber >= 200020 and DealNumber <=200050

OR DealNumber = 900000;

hopkinsc — Fri, 04 Mar 2011 11:10:38 GMT

Thanks Muralidhar, that worked great. Thanks.