Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
crowegreg
Contributor II
Contributor II

Load & Concatanation

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.

1 Reply
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;