Help with load script

hopkinsc — Thu, 25 Nov 2010 09:33:59 GMT

Hi,

In my load script i need to load a field in as a different name but only if another field ='yes'. Below is an example of my fields..

EntryMethod,
SaleDescription,
DiscountGroup,
DiscountAmount,
DiscountApplied,
DiscountLine,
PriceOverride,
AuthorityId,
PromotionType,
MinimumAge,

What i want to do is to load DiscountGroup AS [Stock Movement Reason Code] but only where PriceOverride = 'yes'

This should only give me PriceOverride DiscountGroups.

Can someone tell me how to do this please?

Thanks

Thu, 25 Nov 2010 09:59:08 GMT

Use this

[PriceOverrideDiscountGroups]:

Load

xx,

xxx,

if([PriceOverride]='yes',[DiscountGroup],'') as [Stock Movement Reason Codes],

etc...

topic Help with load script in QlikView