Apply Map with wild Match

[ashwanin]

Hi All,

I have a table in which below data exists. Can you help me to get the desired output as in example shown in last.

Existence
Q-100
Q-146
Q-345
P-145
Z-345
Q-450

In another table i have the like below.

Note
Q-100 reduscion of lack
p-145 asdfj  zedd "#ds
As!"#, azz
Q-345 Desktop%¤¤¤¤
Z-345 In process
Q-100 Authnetication
Q-345 Laptop%¤¤¤¤
Z-345 ddONE

Requirement : I want data of Note in front of Existence, where it will match the initials e.g in below Existence contains Q-100 While same is under Note. .

Existence	Note
Q-100	Q-100 reduscion of lack Q-100 Authnetication

and like this the data will reflect in front of q-146, Q-345 and so on.

[marcus_sommer · Accepted solution]

Perhaps you could simply make a new field within your table "Note":

t:

Load

     Note,

     left(Note, 5) as Existence

.....

- Marcus

[maxgro]

SCRIPT

Source:

LOAD Existence

FROM

[http://community.qlik.com/thread/108934]

(html, codepage is 1252, embedded labels, table is @1);

join (Source)

LOAD Note

FROM

[http://community.qlik.com/thread/108934]

(html, codepage is 1252, embedded labels, table is @2);

Table:

noconcatenate LOAD *

Resident Source

where WildMatch(Note, '*' & Existence & '*')

;

DROP Table Source;

RESULT

Existence	Note
P-145	p-145 asdfj zedd "#ds
Q-100	Q-100 Authnetication
Q-100	Q-100 reduscion of lack
Q-345	Q-345 Desktop%¤¤¤¤
Q-345	Q-345 Laptop%¤¤¤¤
Z-345	Z-345 ddONE
Z-345	Z-345 In process

[ashwanin]

Thanks Marcus and Massimo.