Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Load Statement Help

I am trying to trim down my records to a specific group of names from one table. Here is what I have thus far...

OBSNAME_Sort:

Load * Inline [

NAME

LDL

A1c

BP Systolic

BP Diastolic

Diabetic Eye Exam

Smoking Status

DM Retinopathy

Smoking Cessation

DM Foot Exam

];

Flowsheet:

LOAD HDID,

    NAME;

SQL SELECT HDID,

    NAME

FROM xxx.xxx.FLOWSHEETLABELS;

DROP Table OBSNAME_Sort;

With this I can organize the record names with this statement but I need to condense the record names to this list alone otherwise I'm still getting hundreds of flowsheet names and values associated with those names.

How do I trim the table "NAME" down to give me only the records listed above and dismiss any other record? 

THANKS!

1 Solution

Accepted Solutions
Not applicable
Author

That did the trick... Thanks!

View solution in original post

3 Replies
phaneendra_kunc
Partner - Specialist III
Partner - Specialist III

use Where exists command..

OBSNAME_Sort:

Load * Inline [

NAME

LDL

A1c

BP Systolic

BP Diastolic

Diabetic Eye Exam

Smoking Status

DM Retinopathy

Smoking Cessation

DM Foot Exam

];

Flowsheet:

LOAD HDID,

    NAME where exists (NAME);

SQL SELECT HDID,

    NAME

FROM xxx.xxx.FLOWSHEETLABELS;

DROP Table OBSNAME_Sort;

Not applicable
Author

That did the trick... Thanks!

phaneendra_kunc
Partner - Specialist III
Partner - Specialist III

Can you mark this post as answered/helpful so that rest can find this thread useful.