topic Re: Map SubString using ApplyMap in QlikView

Map SubString using ApplyMap

poluvidyasagar — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I am trying to map a value from an inline table but I want to get only left substring of the mapping value.

Example:

I want to map Part A using apply map function to only Val field value (3).

Similarly, for B I want to get 4 and so on.

Can someone let me know how to achieve this?

Thanks,

sunny_talwar — Mon, 30 Apr 2018 13:44:22 GMT

May be this

SubField(ApplyMap('MappingTableName', Part, Null()), '|', 1) as ....

aunahsan — Mon, 30 Apr 2018 13:47:16 GMT

you can use the left function. it would be Left(Val|Country, 1)

this should return most character in the field, which is what you're looking for

here is the syntax: Left(text, count )

sasiparupudi1 — Mon, 30 Apr 2018 19:01:31 GMT

may be change your mapping load

Map_table:

Mapping Load

Part

SubField([Val|Country],'|',1) as Val

From your table;

alis2063 — Sun, 31 Mar 2019 08:45:02 GMT

Hey Please find the below scripts,