Seperation of data by using different table names

[pavanthota]

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:

a,

b,

c

from ;

Table 2:

a,

b,

c

from  ;

Table 3:

a,

b,

c

from ;

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

[Jason_Michaelides]

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

a,

b,

c

from ;

Table 2:

NoConcatenate

LOAD

a,

b,

c

from  ;

Table 3:

NoConcatenate

LOAD

a,

b,

c

from ;

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

Hope this helps,

Jason

[#3]

Hope this helps!

Table 1:
LOAD
a,
b,
c,
'Table 1' AS TableName
from ;
Table 2: 
NoConcatenate
LOAD
a,
b,
c,
'Table 2' AS TableName
from  ;
Table 3:
NoConcatenate
LOAD
a, 
b,
c,
'Table 3' AS TableName
from ;

[#4]

Please let me know does it helps?

[pavanthota]

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

[Jason_Michaelides]

Please post your app.

[pavanthota]

Hi Jason

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

[Anonymous]

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!