1 Reply Latest reply: Jul 9, 2018 4:48 PM by Nicole Smith RSS

    Load & Concatanation

    Greg Crowe

      Hello,

      I'm having difficulty getting the data into Qlik Sense as required by my existing dashboards.

       

      Here are my current load statements:

      Sitelist:

      Load

          dv_task as [Source Incident] ,dv_location as Site;

      SQL

      SELECT

          dv_task ,dv_location

      FROM

          task_location

      WHERE dv_task = 'INC12449518';

      left Join (Sitelist)

      Load

          full_name as Site

          ,pick(WildMatch(u_region

                      ,'*5*'

                      )

              ,'Region 5 (WA,OR)'

          ) as Region;

      SQL

      SELECT

          full_name

          ,u_region

      FROM

          cmn_location

      WHERE

          "u_active" <> '0';

      The results are the following:

      Here's what I'm needing:

      Source Incident
      Site
      Region
      INC12449518St. Francis Hospital Federal Way ; Family Birthing CenterRegion 5(WA,OR)

       

      I've been able to group on the site, but can't figure out how to add the Region field.