Problem with Mapping substring values

[idodel]

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_code	Tag
12345	Startup, 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

[settu_periasamy · Accepted solution]

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]

awesome,

i made it

thanks