topic Re: Search string with field content in QlikView

Search string with field content

tiklabaq — Mon, 28 Aug 2017 15:25:26 GMT

Hi Friends,

I need your help. How can I make a search in a string with field content from another table, for example a helping csv.

For example:

Table1:

in the csv file will be the string to search and the result to show:

Table2:

Now I need something like this:

if(substringcount(Description,String)>0,Data)

The result should be so:

Thank you very much

Best Regards,

Ibrahim

sunny_talwar — Mon, 28 Aug 2017 15:30:06 GMT

Try with MapSubString()

MappingTable:

Mapping

LOAD String,

'/' & Data & '\' as Data;

LOAD * INLINE [

String, Data

BC, Result1

GH, Result2

K, Result3

XY, Result4

];

FactTable:

LOAD Description,

TextBetween(MapSubString('MappingTable', Description), '/', '\') as Data;

LOAD * INLINE [

Description

ABCD

EFGH

IKL

XYZ

];

tiklabaq — Mon, 28 Aug 2017 16:02:39 GMT

Thank you very much Sunny. It works