topic Re: Concatenate field & subfield in QlikView

Concatenate field & subfield

Thu, 12 May 2016 14:01:50 GMT

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!

Re: Concatenate field & subfield

sunny_talwar — Thu, 12 May 2016 16:38:51 GMT

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

tamilarasu — Thu, 12 May 2016 17:27:33 GMT

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.

Re: Concatenate field & subfield

Fri, 13 May 2016 07:18:45 GMT

Thank you very much, this solved it!

Re: Concatenate field & subfield

Fri, 13 May 2016 07:19:32 GMT

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!