Multivaluated cells

[#1]

Hi Comm,

Does anbody happen to know to script load a multivaluated cell excel file ? cell values are separated by ' ;'

Thanks!

[#2]

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>

[Colin-Albert]

Is there a space after the semicolon in the subfield command, can you try it without the space.

';'  rather than '; '

[#4]

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>

[#5]

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>

[Colin-Albert]

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;

[#7]

its working...

see below screenshot

[#8]

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>

[#9]

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>

[MarcoWedel]

Hi,

just select correct answer and/or helpful in your thread at the posts that helped you or solved your problems..

thanks

regards

Marco