topic Re: Genrice Name Required in QlikView

Genrice Name Required

Anonymous — Wed, 28 Jun 2017 14:52:31 GMT

I Have a column which hold different name like

Example 1:

1]Mark and Might

2]Mark & MIght

3]mark and might

Output : Mark and Might

Example 2:

1]amazon.in

2]amazon.us

3]amazon.uk

Output :Amazon

I want output as above mentioned

Like wise i have different fields with different name

Re: Genrice Name Required

aarkay29 — Wed, 28 Jun 2017 15:04:48 GMT

you have to do something like this in the script

If(WildMatch(Field ,'Mark*'),'Mark and Might',

If(WildMatch(Field ,'Amazon*'),'Amazon'),Field) as NewField

Re: Genrice Name Required

bobbyn4u — Wed, 28 Jun 2017 15:26:15 GMT

You can use a wildmatch function in the script . Below example is the qlikview load:

Load *

from Salesforce_Data_global.qvd(qvd) WHERE WildMatch(Field ,'Amazon*'

)

It will work as a 'Start with' function in Salesforce i.e If the word starts with Amazon, it will pull the entire names.

Here is the detailed explanation:

wildmatch ‒ QlikView

Re: Genrice Name Required

Anonymous — Wed, 28 Jun 2017 15:33:41 GMT

I think we can handle the same Using Appplymap ,by putting repeated name in Excel and plotting final name.

Is there any procedure to handle at the script level,because i Have many data discrepancy in the above way !!

Can anyone tell me the steps to handle in the script

Re: Genrice Name Required

aarkay29 — Wed, 28 Jun 2017 15:58:43 GMT

The only thing that i can think of is

You have to manipulate based on the scenarios.

For the given scenarios would be

something like

Load

If(WildMatch(Field,'*.*'),subfield(Field,'.',1),Field) as Field; // For 2nd scenario

Load

Upper(Replace(Field,'&','and') as Field // For 1st scenario

From table;

Re: Genrice Name Required

Kushal_Chawda — Wed, 28 Jun 2017 17:18:40 GMT

LOAD *,

if(wildmatch(lower(Field),'mark*might','Mark and Might',

if(wildmatch(lower(Field),'*amazone*','Amazon',Field)) as NewFeld

FROM table