Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
idodel
Contributor III
Contributor III

Problem with Mapping substring values

Hi everyone,

I have a problem with linking 2 tables. Qlikview shows null cells for clients which have more than 1 tags.

the tables are:

customers data:

client_code

other field

other field

customers tags data:

client_code

tag_name

 

need to show for each row of the customers data the corresponding tags.

for example:

if the client 12345 has 2 rows of different tags (E.G- Startup and Finance) in the tags table , the new field  (Tag) will contain 'Startup, Finance' value. like:

client_codeTag
12345Startup, Finance

 

I was thinking about Mapsubstring() function but that means I need to upload in the inline all my clients info - much rows

What is the best way to solve  it ?

Thanks

Labels (2)
1 Solution

Accepted Solutions
settu_periasamy
Master III
Master III

if you need the combined tag values for each client_code,  You can use the concat function like

Load

client_code,

Concat(tag_name,',') as tag

From tablename group by client_code;

 

Concat(Ta

 

View solution in original post

2 Replies
settu_periasamy
Master III
Master III

if you need the combined tag values for each client_code,  You can use the concat function like

Load

client_code,

Concat(tag_name,',') as tag

From tablename group by client_code;

 

Concat(Ta

 

idodel
Contributor III
Contributor III
Author

awesome,

i made it

thanks