Genrice Name Required

[Anonymous]

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 

[aarkay29]

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

[bobbyn4u]

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

[Anonymous]

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

[aarkay29 · Accepted solution]

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;

[Kushal_Chawda]

LOAD *,

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

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

FROM table