Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
thnkgreen
Contributor

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

Re: Inline Table From Result Set of previous Load Statement

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.

Re: Inline Table From Result Set of previous Load Statement

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

Community Browser