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]

Hi,

Give me a some sample data and what/how exactly you want?

Vinay

[Colin-Albert]

Have a look at the subfield command, this can expand the data into individual rows for each value.

[#4]

Project                         Contact Name   

WARSAW                    Ana

WARSAW; ITALY        John    

ITALY                         Peter

Above is the excel I have, two columns.

Once I normal load into QVW and later I make a Project filter I have three Projects, but shold be only two.

Does it make sense to you?

Many thanks!

[Colin-Albert]

TRY THIS

LOAD

     SUBFIELD(Project, ';') AS Project,

     [Contact Name]

FROM

[PROJDATA.xlsx]

(ooxml, embedded labels, table is Sheet1);

[Colin-Albert]

Trim added below to remove extra spaces

LOAD

     trim(SUBFIELD(Project, ';')) AS PROJECT,

     [Contact Name]

FROM

(ooxml, embedded labels, table is Sheet1);

[MarcoWedel]

LOAD Subfield(Project, ';') as Project,

          [Contact Name]

From yourdatasource;

should deliver :

Project                         Contact Name  

WARSAW                    Ana

WARSAW                    John 

ITALY                           John   

ITALY                           Peter

hope this helps

regards

Marco

[#8]

Thanks Colin, I’m trying now.

De: Colin Albert

Enviado el: lunes, 08 de septiembre de 2014 18:33

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/604368?et=watches.email.thread#604368>

[#9]

Hi Colin, negative…☹ did not work, as you see they are not trimmed…any other sugestion?

De: Colin Albert

Enviado el: lunes, 08 de septiembre de 2014 18:33

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/604368?et=watches.email.thread#604368>

[#10]

Hi,

Colin & Marco both correct you can use SUBFIELD.

Vinay