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

Concatenate field & subfield

Hello,

I am trying to concatenate a subfield (Device_Type), created by myself through script code, with an existing field ([Software version]) from the data source (being an .xlsx). Below is the piece of code that seems to be giving the error in bold:

DefectsList:

QUALIFY *;

UNQUALIFY [Defect ID], [JIRA ID];

LOAD DISTINCT

     SubField(Device, ';') as Device_Type,

     [Software version],

     Device_Type&' '&[Software version] as Device_Software

FROM

[$(vPathName)bronbestand QV.xlsx]

(ooxml, embedded labels);

UNQUALIFY *;

There doesn't seem to be an awful lot about it on the web, so help would be most welcome, thank you!

4 Replies

Re: Concatenate field & subfield

Try this by taking the Device_Type and Software conversion concatenation to the preceding load.

QUALIFY *;

UNQUALIFY [Defect ID], [JIRA ID];

DefectsList:

LOAD *,

     Device_Type&' '&[Software version] as Device_Software;

LOAD DISTINCT

     SubField(Device, ';') as Device_Type,

     [Software version]

FROM

[$(vPathName)bronbestand QV.xlsx]

(ooxml, embedded labels);

UNQUALIFY *;

Re: Concatenate field & subfield

Hi Robin,

You can try,

QUALIFY *;

DefectsList:

LOAD DISTINCT

    SubField(Device, ';') as Device_Type,

    [Software version],

    SubField(Device, ';')  &' '& [Software version] as Device_Software

FROM

[$(vPathName)bronbestand QV.xlsx]

(ooxml, embedded labels);


UNQUALIFY *;


UNQUALIFY [Defect ID], [JIRA ID] => You don't need this line, since you are not loading these two fields from excel.


Not applicable

Re: Concatenate field & subfield

Thank you very much, this solved it!

Not applicable

Re: Concatenate field & subfield

Hi Tamil,

My apologies. These fields actually are being loaded, but I forgot to delete them. I simply only wanted to post the relevant code. Thanks anyways!

Community Browser