4 Replies Latest reply: May 13, 2016 3:19 AM by Robin Neven RSS

    Concatenate field & subfield

    Robin Neven

      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!