
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Excluding ID's with IF and ApplyMap
Hi,
I would like some help with the following:
I'm working with a project that needs to separate certain ID's from a field. One ID (12345) was already separated before (by someone else), and now they want to exclude one more ID (34512). The code that was used to exclude the first ID is:
mapUniqueID:
MAPPING LOAD autonumber(%Key_FactoryOrder), [Unique ID]
FROM *****.qvd (QVD)
;
if(num(%Key_Dealer)=1 AND applymap('mapUniqueID',autonumber(%Key_FactoryOrder))='12345','12345',%Key_Dealer) AS [Retailer],
I've tried so many different options but with no luck. Is there a simple way to fix it? E.g.
if(num(%Key_Dealer)=1 AND applymap('mapUniqueID',autonumber(%Key_FactoryOrder))='12345','12345',%Key_Dealer,
if(num(%Key_Dealer)=1 AND applymap('mapUniqueID',autonumber(%Key_FactoryOrder))='34512','34515',%Key_Dealer)) AS [Retailer],
It should be quite easy but I've been sitting with it for a while now and I can't get it to work.
Sincerely
K

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
The syntax if is: If(condition, TrueActions, FalseActions).
Nested different If's (the FalseActions is another If): If(condition, TrueActions, If(condition, TrueActions, FalseActions)).
So tou can try this:
if(num(%Key_Dealer)=1 AND applymap('mapUniqueID',autonumber(%Key_FactoryOrder))='12345'
,'12345'
, if(num(%Key_Dealer)=1 AND applymap('mapUniqueID',autonumber(%Key_FactoryOrder))='34512'
,'34515'
,%Key_Dealer
)
) AS [Retailer],

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Might be easier to just do this
If(Num(%Key_Dealer) = 1 and Match(ApplyMap('mapUniqueID', AutoNumber(%Key_FactoryOrder)), '12345', '34515'),
ApplyMap('mapUniqueID', AutoNumber(%Key_FactoryOrder)),
%Key_Dealer
) AS [Retailer],

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I don't know why, but when I click the 'Like' button it seems that doesn't works.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Not sure why would that be... seems to be working okay for me. Does this happen only for this post or any post?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Any post, I wasn't aware until now. I wonder how many likes has been lost

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
That is strange, may be @Brett_Bleess can help us figure this out.
