concat

[Bubskim]

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 

[Lisa_P]

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]

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]

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]

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]

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]

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]

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]

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

[Bubskim]

We may be getting close.

What is this in the load?

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