topic Re: Inline Table From Result Set of previous Load Statement in QlikView

Inline Table From Result Set of previous Load Statement

Anonymous — Thu, 09 Jan 2014 15:09:35 GMT

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

Re: Inline Table From Result Set of previous Load Statement

Thu, 09 Jan 2014 15:41:57 GMT

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

Anonymous — Thu, 09 Jan 2014 20:38:37 GMT

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