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: 
Bubskim
Contributor II
Contributor II

concat

Please help me combine two emails into one so they show as one in my chart.

exampleemail

exampleemail@example.com

^ I would like these two above to show as exampleemail and be grouped together 

11 Replies
Lisa_P
Employee
Employee

One way to achieve this is with a mapping table.

Either create inline or from an external table a simple lookup with oldname and new name.

eg

RenameMap:

Load * inline [

OldName, NewName

exampleemail@example.com, exampleemail

.

.

];

Then when you are ready to load the field

Load 

.

.

Applymap('RenameMap', Email) as Email,

.

 

 

Bubskim
Contributor II
Contributor II
Author

Hi where am I putting each one of those? in the script? 

I was able to do this 

 

Load * inline [exampleemail@example.com, exampleemail];

 

but idk what to do with your bottom part?

lockematthewp
Creator II
Creator II

The easiest solution would be as follows:

Load ...

subfield([EmailAddress], '@', 1) as [EmailAddress],

From ...

This will basically remove the @whatever.com from every email address. Then any matches are automatically grouped together.

Bubskim
Contributor II
Contributor II
Author

I do not get it. 

In the load is this for the load script?

Here is what I did 


Load

subfield([Sent By], 'exampleemail@example.com', 1) as [exampleemail],

Bubskim
Contributor II
Contributor II
Author

also here is another example based on what you gave me to work with!

 

I need to have a specific name of a box truncate into 1. The text between is the name of the box with the type of alert like disk space.

load 


subfield([Sent By], 'specificname*Disk_Space*', 1), If(WildMatch([Sent By], '*specificname*:Disk_Space*'), TextBetween ([Sent By], 'specificnamewithnumbers*','')) as [specificname Disk Space],

rutger_jansen
Contributor III
Contributor III

Hi,

Attached is what the other members are describing. Can you provide examples of your other question in a qvw for us to look at?

 

Bubskim
Contributor II
Contributor II
Author

Hi thank you for doing that. I can use it for something else. 

However, instead of displaying the sum I need to do the exampleemail@example.com as one = exampleemail . I do not need the sum, I need it to come out as one on my chart 

 

rutger_jansen
Contributor III
Contributor III

Do you mean a count of unique email addresses, as per attached?

Bubskim
Contributor II
Contributor II
Author

We may be getting close.

 

What is this in the load?

 

LOAD * INLINE [
email, size
exampleemail, 5
exampleemail@example.com, 15
];