Load & Concatanation

[crowegreg]

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
INC12449518	St. Francis Hospital Federal Way ; Family Birthing Center	Region 5(WA,OR)

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

[Nicole-Smith]

After the code that you already have, try adding this:

Sitelist_Final:
LOAD [Source Incident],
    Region,
    CONCAT(Site, '; ') AS Site
RESIDENT Sitelist
GROUP BY [Source Incident], Region;

DROP TABLE Sitelist;