Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
A simple question, I just don't know technical wording to do a proper search on this forum, as I am sure solution already exists..
So in my simple words.
I have a data table (first Inline in my attachment). I need to add one more dimension, containing market name. it is a rule that each account can cover only one market code, and most of them do cover a domestic market code (let's say that the domestic is Spain).
Problem: I would like to see Spain for all those records that are missing in my 2nd Inline load of attached report. That way, in my 2nd Inline, I limit the data only to those with other than Spain market names.
Thanks a lot for your help
You can use a mapping table and the applymap function. See attached example.
I was tryin to apply your logic to the conditions being closer to the report I am trying to build - have a look in the attachment.
I can not get "Spain" in all empty rows - what am I doing wrong//??
Thanks a lot for your help.
Draszor
I attach the files - may !be this time they o through
Hi,
v_Account is not know in your applymap, use ApplyMap('MapMarket',Left(Account,3), 'Spain') as MarketCode, instead