Straight Table Concatenation of two columns

[brucemazynzolt]

Hi All,

I am trying to get the require column(Final Data) in the below table

I have two columns in my straight table called Data1 and Data2 so I need to concatenate and get the required column called Final Data and this should be done in design level only, not in script level.

Data1	Data2	Final Data
-	AP	AP
-	abcdef	-
Packing	AP	AP / Packing
Packing	abcdef	abcedf
-	-	-

Any suggestions or help is highly appreciated.

Thanks,

Bruce

[Chanty4u]

try

=Data1&Data2

[Chanty4u]

or

Data1 &' '& Data2 as  FieldData

[Digvijay_Singh]

Whats the logic to calculate Final Data. The output you have shown looks like not following any pattern. May be I am missing something?

[isingh30]

What's the logic behind this requirement. It's very confusing. First result is AP & second one is null why?

Why last result is data 2 not 1?

Thank you!

[brucemazynzolt]

Here the Data2 column data 'AP' is important to display.

Yes you are right we need to write logic to display the data as shown in the table

Thanks

[isingh30]

'important to display' is not a logical thing. You have to work on you requirement part. There has to be a criteria for everything.

Thank you!

[zebhashmi]

Your Table does not have Logic.

if you just want then togaher

yes

Data1&'/'&Data2

will work otherwise you can use if on the top of it.