Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
try
=Data1&Data2
or
Data1 &' '& Data2 as FieldData
Whats the logic to calculate Final Data. The output you have shown looks like not following any pattern. May be I am missing something?
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!
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
'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!
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.