Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;
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
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:
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
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;
LOAD *,
if(wildmatch(lower(Field),'mark*might','Mark and Might',
if(wildmatch(lower(Field),'*amazone*','Amazon',Field)) as NewFeld
FROM table