Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
T_Qlik
Contributor III
Contributor III
‎2024-04-18 06:02 AM

Concat using Distinct

Tarun_Qlik_0-1713434470389.png

Replace (Concat(distinct KPI,''),',', ' * ')

Labels (3)
Labels
232 Views
1 Solution

Accepted Solutions
MayilVahanan
MVP
MVP
‎2024-04-18 06:10 AM

Hi

Try like below

Load *, trim(SubField(KPI,',')) as KPI1 Inline
[
KPI
Sales, Customer
Sales, Source
](delimiter is '|');

Exp:

=Concat(distinct KPI1,'*')

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

226 Views
0 Likes
2 Replies
MayilVahanan
MVP
MVP
‎2024-04-18 06:10 AM

Hi

Try like below

Load *, trim(SubField(KPI,',')) as KPI1 Inline
[
KPI
Sales, Customer
Sales, Source
](delimiter is '|');

Exp:

=Concat(distinct KPI1,'*')

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
227 Views
0 Likes
T_Qlik
Contributor III
Contributor III
‎2024-04-18 07:52 AM
Author

Thanks Man!

196 Views
0 Likes