Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Comm,
Does anbody happen to know to script load a multivaluated cell excel file ? cell values are separated by ' ;'
Thanks!
Sorry, does not work, see below…
ContactosOutLook:
LOAD trim(subfield(Categories, '; '))as Categories,
ContactosNombre,
ContactosOrganizacion,
ContactosDepartamento,
ContactosPuesto,
ContactosMobilePhone,
ContactosEmailAddress
FROM
De: Marco Wedel
Enviado el: lunes, 08 de septiembre de 2014 18:35
Para: Quintero, Borja @ Madrid
Asunto: Re: - Multivaluated cells
Qlik Community<http://community.qlik.com/>
Multivaluated cells
reply from Marco Wedel<http://community.qlik.com/people/MarcoWedel?et=watches.email.thread> in Scripting - View the full discussion<http://community.qlik.com/message/604370?et=watches.email.thread#604370>
Is there a space after the semicolon in the subfield command, can you try it without the space.
';' rather than '; '
Hi Vinay, It does not work, see below…any suggestions?
ContactosOutLook:
LOAD trim(subfield(Categories, '; '))as Categories,
ContactosNombre,
ContactosOrganizacion,
ContactosDepartamento,
ContactosPuesto,
ContactosMobilePhone,
ContactosEmailAddress
FROM
De: Vinay Naran
Enviado el: lunes, 08 de septiembre de 2014 18:40
Para: Quintero, Borja @ Madrid
Asunto: Re: - Multivaluated cells
Qlik Community<http://community.qlik.com/>
Multivaluated cells
reply from Vinay Naran<http://community.qlik.com/people/VINAYNARAN?et=watches.email.thread> in Scripting - View the full discussion<http://community.qlik.com/message/604373?et=watches.email.thread#604373>
mmm…I have tried but same problem..albeit subfield should work as I’m looking into community…not a clue why is not working but still have projects which name is a mixture of projects instead of being one by file-
De: Colin Albert
Enviado el: lunes, 08 de septiembre de 2014 18:43
Para: Quintero, Borja @ Madrid
Asunto: Re: - Multivaluated cells
Qlik Community<http://community.qlik.com/>
Multivaluated cells
reply from Colin Albert<http://community.qlik.com/people/Colin_Albert?et=watches.email.thread> in Scripting - View the full discussion<http://community.qlik.com/message/604391?et=watches.email.thread#604391>
Does your spreadsheet load include wildcards? Some functions do not work when loading using wildcards.
Or do you have qualify enabled?
Try loading from your spreadsheet into a temp table and then doing a resident load to apply the subfield command.
tmpProjects:
LOAD
Project,
[Contact Name]
FROM
(ooxml, embedded labels, table is Sheet1);
Projects:
NoConcatenate
load
trim(SUBFIELD(Project, ';')) AS Project,
[Contact Name]
resident tmpProjects ;
drop table tmpProjects;
its working...
see below screenshot
Right! It works ☺ I was having data waste and it was confusing me. But now it works.
Many thanks.
BQ.
De: Vinay Naran
Enviado el: lunes, 08 de septiembre de 2014 18:54
Para: Quintero, Borja @ Madrid
Asunto: Re: - Multivaluated cells
Qlik Community<http://community.qlik.com/>
Multivaluated cells
reply from Vinay Naran<http://community.qlik.com/people/VINAYNARAN?et=watches.email.thread> in Scripting - View the full discussion<http://community.qlik.com/message/604395?et=watches.email.thread#604395>
Hi Colin ,not necessary, I Works perfectly. How can I tip points?
Best,
BQ.
De: Colin Albert
Enviado el: lunes, 08 de septiembre de 2014 18:52
Para: Quintero, Borja @ Madrid
Asunto: Re: - Multivaluated cells
Qlik Community<http://community.qlik.com/>
Multivaluated cells
reply from Colin Albert<http://community.qlik.com/people/Colin_Albert?et=watches.email.thread> in Scripting - View the full discussion<http://community.qlik.com/message/604394?et=watches.email.thread#604394>
Hi,
just select correct answer and/or helpful in your thread at the posts that helped you or solved your problems..
thanks
regards
Marco