topic Compare substring in ApplyMap() in QlikView

Compare substring in ApplyMap()

bobbydave — Sat, 16 Nov 2024 04:44:42 GMT

I have a mapping table.

Keyword App

xxxxxx .NET

YYYYYY APACHE

ZZZZZ OFFICE

I have a table then and within this table, column H has

Table:

Load H

From

X.xlsx

H contains output:

sdfsdxxxxxxdsfdsf

ERWRWWQYYYYYYAEWRA

IOPIOPIZZZZZOIPOIO

I need to be able to check if column H has the keywords and then bring in the App as an object of Table.

TIA

Re: Compare substring in ApplyMap()

sunny_talwar — Wed, 16 Jan 2019 12:53:07 GMT

May be look here

MapSubString

Re: Compare substring in ApplyMap()

bobbydave — Wed, 16 Jan 2019 13:27:38 GMT

I've used MapSubString but I keep getting the value of H as the full line of the string returned when all I want is the keyword.

Re: Compare substring in ApplyMap()

sunny_talwar — Wed, 16 Jan 2019 13:45:16 GMT

Something like this?

MappingTable:
Mapping
LOAD Keyword,
	 '/' & App & '\';
LOAD * INLINE [
    Keyword, App
    xxxxxx, .NET
    YYYYYY, APACHE
    ZZZZZ, OFFICE
];

Table:
LOAD H,
	 TextBetween(MapSubString('MappingTable', H), '/', '\') as App;
LOAD * INLINE [
    H
    sdfsdxxxxxxdsfdsf
    ERWRWWQYYYYYYAEWRA
    IOPIOPIZZZZZOIPOIO
];

Re: Compare substring in ApplyMap()

pradosh_thakur — Wed, 16 Jan 2019 14:00:47 GMT

Hi Sunny,

why is '/' AND '\' needed to be concatenated to App?

Re: Compare substring in ApplyMap()

sunny_talwar — Wed, 16 Jan 2019 14:14:16 GMT

MapSubString will replace Keyword with App in the string... in order to extract just the app (using TextBetween), I added / and \ to the App.