Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
manoj217
Creator III
Creator III

concatenate 2 fields vertically

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

9 Replies
kenphamvn
Creator III
Creator III

Hi

Try this

TBLA:

load [file name], owner

from table 1;

concatenate(TBLA)

load [file name1], owner

from table2;

Regards

manoj217
Creator III
Creator III
Author

i want this in front end only in a straight table

timpoismans
Specialist
Specialist

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

manoj217
Creator III
Creator III
Author

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
Partner - Creator II
Partner - Creator II

Hi!

Dimension Owner

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

Does this solve your problem?

timpoismans
Specialist
Specialist

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

Consider Table1:

FileNameValues
a1

Consider Table2:

FileName1Values
b1

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

FileNameFileName1Values
a1
b1

But you can't get the following:

FileName OR FileName1

Values

a1
b1
manoj217
Creator III
Creator III
Author

Any other way to achieve please let me know

timpoismans
Specialist
Specialist

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:

FileNameValuesFileName1 data
a10

Consider Table2:

FileName1ValuesFileName1 data
b11

Rename FileName1 to FileName:

FileNameValuesFileName1 data
b11


Concatenate these and:

FileName OR FileName1

Values

FileName1 data

a10
b11

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
Creator III
Creator III
Author

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