Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Genrice Name Required

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 

1 Solution

Accepted Solutions
aarkay29
Specialist
Specialist

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;


View solution in original post

5 Replies
aarkay29
Specialist
Specialist

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
Contributor III
Contributor III

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
Not applicable
Author

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
Specialist
Specialist

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