topic Apply Map with wild Match in QlikView

Apply Map with wild Match

ashwanin — Thu, 27 Feb 2014 13:45:42 GMT

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.

Re: Apply Map with wild Match

marcus_sommer — Thu, 27 Feb 2014 14:05:21 GMT

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

Load

Note,

left(Note, 5) as Existence

.....

- Marcus

Re: Apply Map with wild Match

maxgro — Thu, 27 Feb 2014 21:39:28 GMT

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

Re: Apply Map with wild Match

ashwanin — Fri, 28 Feb 2014 09:11:18 GMT

Thanks Marcus and Massimo.