Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi
i have table 1, table 2, table 3, table 4 which has a common field Application Name but the data for that field is different in all the tables, very few names are matching, but in my dashboard, in the list box i have to get all the application names from all the tables.
so i have written:
Data1:
Laod [Application name],
[support Group]
from *****************
Data2:
Load [Application Name],
location
from ******
like this i ahve written 2 more tables.
but i have not concatenated, as i have taken the name as [Application name]
do i need to concatenate all the tables to get all the application names from all the tables in the list box
please suggest
Concatenation is not required...even on join or link you will get all the values in one field.
Just rename required data field as [Application Name]
force the concatenate by using:
Data2:
concatenate (Date1)
load
[Application Name],
location
from ******
Data3:
concatenate (Date1)
load ...
No need to concatenate, you would get all members in that field.
don't concatenate.
In QlikView, if the number of fields and field names of two or more tables are same then the tables are Concatenated into one table.
In your case once you load all your tables, you will get all the application names from all the tables in a list box.
Concatenation is not required...even on join or link you will get all the values in one field.
Just rename required data field as [Application Name]