Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Bubskim
Contributor II
Contributor II

I need to concat or aggregate two similar values so they show up as one

Hi all,

How do I concat this example?

Email - example@gmail.com

email- example

both emails are the same the one has the @gmail.com at the end. I need to join them to display as one in my chart. This can be in the load or in the expression. 

Aggr(If((Count(DISTINCT)["example", "example@gmail.com"]) = ERROR

Count(DISTINCT)["example", "example@gmail.com"]) = ERROR

capture shows the issue

 

1 Reply
Arthur_Fong
Partner - Specialist III
Partner - Specialist III

Hi,

Attached is the requirement you looking for:

Concat.PNG

 

Thanks and regards,

Arthur Fong