topic Re: ApplyMap with SubField in QlikView

ApplyMap with SubField

pascos88 — Mon, 11 Jan 2016 12:31:22 GMT

Hello,

It is possible to use ApplyMap and inside Sub field?

I need somethings like this

MAP_TURBINE:

Mapping load * inline [

Turbine, NormTurb

WTG01, E1

WTG02, E2

WTG03, E3

WTG04, E4

WTG05, E5

WTG06, E6

];

ApplyMap('MAP_TURBINE', SubField(FileBaseName(),'_',4) then NormTurb, SubField(FileBaseName(),'_',4) as Turbine;

I know that the script is wrong, but I want if SubField(FileBaseName(),'_',4) = WTG01 or WTG02 ... or WTG06 so I need to rename in NormTurb.

Thanks for any help

Pasquale

Re: ApplyMap with SubField

marcus_sommer — Mon, 11 Jan 2016 12:51:36 GMT

Maybe in this way:

ApplyMap('MAP_TURBINE',

if(match(SubField(FileBaseName(),'_',4), WTG01, WTG02, ..., WTG06), NormTurb, SubField(FileBaseName(),'_',4)), 'ApplyMapDefaultValueForNotFound') as Turbine;

- Marcus

Re: ApplyMap with SubField

ysj — Thu, 18 Jan 2018 13:12:29 GMT