topic Re: Seperation of data by using different table names in QlikView

Seperation of data by using different table names

pavanthota — Wed, 23 May 2012 14:11:57 GMT

Hi,

I have 3 final tables in one qlikview application having same field names after writing all my code in Editscript. i want to seperate the data by using table names for presentation purpose can anyone help me on this. I am proving the example below . I tried to using "Qualify " but my code is giving error some field is not found even i have that field in that script(Field is Key field). After removing "Qualify everything went fine but all the data is showing u;nder first table only its not showing second and third tables when i press ctrl+T.

Table 1:

from ;

Table 2:

from ;

Table 3:

from ;

When i am going to present the data its showing all three tables data showng Table 1: only can anyone help on this

Seperation of data by using different table names

Jason_Michaelides — Wed, 23 May 2012 15:53:44 GMT

The reason tables 2 and 3 are not showing is that all three tables have the same structure, so QV is concatenating them together. To avoid this use NoConcatenate:

Table 1:

LOAD

from ;

Table 2:

NoConcatenate

LOAD

from ;

Table 3:

NoConcatenate

LOAD

from ;

But be aware that you will end up with a syn table here as the fieldnames are the same.

Hope this helps,

Jason

Re: Seperation of data by using different table names

Mon, 13 Aug 2012 10:25:20 GMT

Hope this helps!

Table 1:

LOAD

'Table 1' AS TableName

from ;

Table 2:

NoConcatenate

LOAD

'Table 2' AS TableName

from ;

Table 3:

NoConcatenate

LOAD

'Table 3' AS TableName

from ;

Re: Seperation of data by using different table names

Tue, 14 Aug 2012 10:30:11 GMT

Please let me know does it helps?

Re: Seperation of data by using different table names

pavanthota — Mon, 01 Oct 2012 12:53:39 GMT

Hi jaoson,

I have tried the above code, when i went and search for table viewer its showing only one table not for three tables can you help me

Thanks,

Pavan

Re: Seperation of data by using different table names

Jason_Michaelides — Mon, 01 Oct 2012 12:55:30 GMT

Please post your app.

Re: Seperation of data by using different table names

pavanthota — Mon, 01 Oct 2012 13:02:49 GMT

Hi Jason

I have attached my app sorry its creating synthetic table. I want without creating synthetic tables and three seperate tables

Re: Seperation of data by using different table names

Anonymous — Fri, 06 Nov 2015 04:38:18 GMT

I have a similar question...

I am trying to do what you would consider a vlookup from 2 columns in table 1 to 2 columns in table 2 and if it is a match, multiply a value in table 1 by the third column in table 2.

Any ideas?

Thanks in advance!