Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Inline Table From Result Set of previous Load Statement

Hello QV buddies.  I'm not sure if this is even possible, but if so, I was hoping someone could explain.  Can you create an inline table from the result set of a previous load statement and keep that inline table in memory for later on in the script??  Thanks  

2 Replies
Not applicable
Author

If you are loading the already loaded table, you RESIDENT function.

MAINTABLE:

LOAD FIELD1, FIELD2, FIELD3, FIELD4 FROM SOURCE ;

SECONDARY:

LOAD DISTINCT FIELD1 Resident MAINTABLE ;

There is another option in INLINE to load from Field values, but for this, we already reload the application.

In the Script Editor,  Insert --> Load Statement --> Click Load Inline

then INLINE wizard will open, then Goto Tools --> Document Data

Then you can see the List of the fields and select one filed and clicl All values and click ok.

Anonymous
Not applicable
Author

thnkgreen


Your question is somewhat ambiguous, but maybe you are after a Preceding Load. 


Have a look at this blog just in case :


     Preceding Load



If it is not what you are after, then read it anyway as Henric's blog posts are always worth a read.



Best Regards,     Bill