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..
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?