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: 
Anonymous
Not applicable

Load ONLY one example

How do I go about loading just 1 example from a list of many? I need something like

Load

Example as [This Example]

From [etc.]

where Example = 'Example1'

and blah = 'example2' and 'example3'

etc.

I just want the table to say-

This Example

     Example1

6 Replies
vishsaggi
Champion III
Champion III

Not sure we quite understood your query.. May be this?

Load

Example as [This Example]

From yoursource

where Example = 'Example1' ;

Colin-Albert

First N limits the load to only N rows.  This only affects the load that follows, other tables will be fully loaded.

First 1

Load

Example as [This Example]

From [etc.]

where Example = 'Example1'

and blah = 'example2' and 'example3'

Anonymous
Not applicable
Author

That's not working. When I put the table in and choose This Example it shows more than one example.

I want it to say this-

GMNA

     GMNA Top 5

Where both are loaded for just their own columns, such as CY 2011, CY 2012, CY 2013, CY 2014, etc. But only for GMNA or GMNA Top 5

vishsaggi
Champion III
Champion III

Sorry did not get you what you looking for can you share some sample with an expected output.

effinty2112
Master
Master

Nicholas,

     Are you loading from a source or a resident table? If resident table then

LOAD

Example as [This Example]

Resident TableName

where Example = 'Example1'

and blah = 'example2' and 'example3'

and RecNo() = 1;

Anonymous
Not applicable
Author

Here's an example of what I want.

Example of GMNA.png