Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Not sure we quite understood your query.. May be this?
Load
Example as [This Example]
From yoursource
where Example = 'Example1' ;
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'
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
Sorry did not get you what you looking for can you share some sample with an expected output.
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;
Here's an example of what I want.