Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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 ;
Please let me know does it helps?
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
Please post your app.
Hi Jason
I have attached my app sorry its creating synthetic table. I want without creating synthetic tables and three seperate tables
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!