topic Re: concatenate 2 fields vertically in QlikView

concatenate 2 fields vertically

manoj217 — Fri, 28 Sep 2018 09:02:14 GMT

i want to concatenate two different fields vertically

For example:

load [file name], owner

from table 1;

load [file name1], owner

from table2;

now i want to concatenate two fields vertically without aliasing.

i want to show this in front end.like

file name -Values

file name1- Values

Re: concatenate 2 fields vertically

kenphamvn — Fri, 28 Sep 2018 09:04:59 GMT

Try this

TBLA:
load [file name], owner
from table 1;

concatenate(TBLA) 
load [file name1], owner
from table2;

Regards

Re: concatenate 2 fields vertically

manoj217 — Fri, 28 Sep 2018 11:06:40 GMT

i want this in front end only in a straight table

Re: concatenate 2 fields vertically

timpoismans — Fri, 28 Sep 2018 11:14:21 GMT

You can't show two different fields in one column.

Re: concatenate 2 fields vertically

manoj217 — Fri, 28 Sep 2018 12:30:01 GMT

back end forced concatenation is enough but i want in front end

if we want to concatenate in horizontal means we use A & B same i want in vertical

Re: concatenate 2 fields vertically

miikkaqlick — Fri, 28 Sep 2018 12:38:32 GMT

Hi!

Dimension Owner

Expression =If(IsNull( [file name]), [file name 1], [file name])

Does this solve your problem?

Re: concatenate 2 fields vertically

timpoismans — Fri, 28 Sep 2018 12:44:30 GMT

What you are trying to do, isn't possible:

Consider Table1:

FileName	Values
a	1

Consider Table2:

FileName1	Values
b	1

If you'd concatenate them, you'd get:

FileName	FileName1	Values
a		1
	b	1

But you can't get the following:

FileName OR FileName1	Values
a	1
b	1

Re: concatenate 2 fields vertically

manoj217 — Fri, 28 Sep 2018 12:47:25 GMT

Any other way to achieve please let me know

Re: concatenate 2 fields vertically

timpoismans — Fri, 28 Sep 2018 12:57:19 GMT

As long as you won't name the fields the same, you won't get their data in the same column.

A possible solution would be:

Consider Table1:

FileName	Values	FileName1 data
a	1	0

Consider Table2:

FileName1	Values	FileName1 data
b	1	1

Rename FileName1 to FileName:

FileName	Values	FileName1 data
b	1	1

Concatenate these and:

FileName OR FileName1	Values	FileName1 data
a	1	0
b	1	1

The Field [FileName1 data] is a flag that you create which you use to indicate if data came from the table of FileName1 or not.

Re: concatenate 2 fields vertically

manoj217 — Fri, 28 Sep 2018 13:27:03 GMT

some expressions is depended on the count of values in table A so i cant change the field names for this i will go with the flags

it will solve my problem but please let me know if any solutions found in my before condition.

thanks for your response