Replace empty field by the word others

[#1]

Hello All,

Could you please help me in replacing the empty space with the word others.

I tried the mapping but it is not working:

mapservicestatus2:

mapping load * inline [

  raison_refus_rendez-vous,Newraison_refus_rendez-vous

  Null(), Autres

  ] ;

AS_XX_XXX:

ApplyMap('mapservicestatus2',[raison_refus_rendez-vous]) as [Newraison_refus_rendez-vous];

And this is my expression:

=Count({<Marquenew={'Citroën'}>}{<[Newraison_refus_rendez-vous]={'Rendez-vous déjà fixé','Véhicule vendu','Entretien déjà effectué','Autres'}>} [Newraison_refus_rendez-vous])

Any idea where I am wrong?

Many Thanks,

Hasvine

[jonathandienst]

I think the '-' values in the chart are 'missing' rather than null and neither script deals with that. I suggest that you post your qvw or a representative sample to see why those values are missing and what can be done to resolve that.

[tamilarasu]

Hi Hasvine,

Seems the  cell value is "{null}".!!! If so try the below one,

TableName:

LOAD

*,

If([raison_refus_rendez-vous] ='{null}' , 'Autres', [raison_refus_rendez-vous]) as [Newraison_refus_rendez-vous]

FROM DataSource;