Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi
Try this
TBLA:
load [file name], owner
from table 1;
concatenate(TBLA)
load [file name1], owner
from table2;
Regards
i want this in front end only in a straight table
You can't show two different fields in one column.
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
Hi!
Dimension Owner
Expression =If(IsNull( [file name]), [file name 1], [file name])
Does this solve your problem?
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 |
Any other way to achieve please let me know
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.
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