topic Re: Problem n to n with n= Name 1, Name 2, Name 3, .... in Connectivity & Data Prep

Problem n to n with n= Name 1, Name 2, Name 3, ....

MCerro — Wed, 01 Feb 2023 10:57:58 GMT

I have a list of tasks and the name of the people that need to do this. The problem is that the name of the people is together in the same place, separated for comas. So I need to create a visualisation on Qlik with a list of this person (individual name) and it visualization show me a list of her/his task. I know that is a typical problem of n to n, but I don't know how to resolve it with the comas in Qlik.

Re: Problem n to n with n= Name 1, Name 2, Name 3, ....

sidhiq91 — Wed, 01 Feb 2023 11:07:41 GMT

@MCerro Could you please try the below code:

NoConcatenate
Temp:
Load Task,
SubField(Name,',',1) as Name1,
SubField(Name,',',2) as Name2,
SubField(Name,',',3) as Name3

Inline [
Task|Name
Task1| James, Richard, Joseph
Task2| James, Richard, Maria

](delimiter is '|');

Exit Script;

If this resolves the issue, please like and accept as a solution.

Re: Problem n to n with n= Name 1, Name 2, Name 3, ....

Renatusfreitas — Wed, 01 Feb 2023 11:44:31 GMT

@MCerro Veja se essa solução lhe atende, no passado precisei usar e encontrei uma publicação do @mario_sergio_ti que me ajudou.

Fiz um Inline para trazer os seus dados como estão.

Agora usando o While, conseguirá capturar os nomes pelos separadores ','

Utilizando o SubField(Trim("Name"), ', ', IterNo(), desta forma terá uma tabela com a tarefa e nome separados

Resultado da carga, acho que irá lhe atender! Se isso resolver o problema, curta e aceite como solução. abraço!!!

Renato Freitas