Compare substring in ApplyMap()

[bobbydave]

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

[sunny_talwar]

May be look here

MapSubString

[bobbydave]

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.

[sunny_talwar · Accepted solution]

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
];

[pradosh_thakur]

Hi Sunny,

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

[sunny_talwar]

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