topic Re: concatenation in QlikView

concatenation

srujanaponnuru — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: concatenation

Anonymous — Tue, 27 Sep 2016 06:16:31 GMT

force the concatenate by using:

Data2:

concatenate (Date1)

load

[Application Name],

location

from ******

Data3:

concatenate (Date1)

load ...

Re: concatenation

tresB — Tue, 27 Sep 2016 06:17:39 GMT

No need to concatenate, you would get all members in that field.

Re: concatenation

varshavig12 — Tue, 27 Sep 2016 06:20:11 GMT

don't concatenate.

Re: concatenation

trdandamudi — Tue, 27 Sep 2016 06:20:19 GMT

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.

Re: concatenation

Anonymous — Tue, 27 Sep 2016 06:22:05 GMT

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]