Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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 ];
May be look here
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.
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 ];
MapSubString will replace Keyword with App in the string... in order to extract just the app (using TextBetween), I added / and \ to the App.