Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
awesome,
i made it
thanks