Assuring all records with no allocation are not null

[#1]

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

[Gysbert_Wassenaar]

You can use a mapping table and the applymap function. See attached example.

[#3]

Hi Gysbert Wassenaar,

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

[#4]

I attach the files - may !be this time they o through

[stabben23]

Hi,

v_Account is not know in your applymap, use ApplyMap('MapMarket',Left(Account,3), 'Spain') as MarketCode, instead