Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Multivaluated cells

Hi Comm,

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

Thanks!

18 Replies
Not applicable

Re: Multivaluated cells

Hi,

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

Vinay

Re: Multivaluated cells

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


Not applicable

Re: Multivaluated cells

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!

Re: Multivaluated cells

TRY THIS

LOAD

     SUBFIELD(Project, ';') AS Project,

     [Contact Name]

FROM

[PROJDATA.xlsx]

(ooxml, embedded labels, table is Sheet1);

Re: Multivaluated cells

Trim added below to remove extra spaces

LOAD

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

     [Contact Name]

FROM

(ooxml, embedded labels, table is Sheet1);

Re: Multivaluated cells

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

Not applicable

Re: Multivaluated cells

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>

Not applicable

Re: Multivaluated cells

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>

Not applicable

Re: Multivaluated cells

Hi,

Colin & Marco both correct you can use SUBFIELD.

Vinay

Community Browser