topic Re: Problem with Mapping substring values in QlikView

Problem with Mapping substring values

idodel — Sat, 16 Nov 2024 17:42:14 GMT

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

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

Re: Problem with Mapping substring values

settu_periasamy — Tue, 15 Dec 2020 13:07:20 GMT

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

Re: Problem with Mapping substring values

idodel — Tue, 15 Dec 2020 13:46:43 GMT

awesome,

i made it

thanks