concatenate 2 fields vertically

[manoj217]

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

[kenphamvn]

Hi

Try this

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

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

Regards

[manoj217]

i want this in front end only in a straight table

[timpoismans]

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

[manoj217]

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

[miikkaqlick]

Hi!

Dimension Owner

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

Does this solve your problem?

[timpoismans]

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

[manoj217]

Any other way to achieve please let me know

[timpoismans]

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.

[manoj217]

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