Help with load script

[hopkinsc]

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

[#2 · Accepted solution]

Use this

[PriceOverrideDiscountGroups]:

Load

xx,

xxx,

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

etc...