Hi Jace,

Without more context, it's hard to guess exactly what you are trying to achieve.

Nevertheless, there's the If built-in function that allows you to return a value depending on some condition. You could leave the expression for column1 always equal to column1. And in column2 you could use:

If (column1 = column2, "", column2)

which will only display column2 if the columns are different.

Is that what you want?

If not, can you provide more context or a sample oml?

Cheers,

José

Hi Jace,

Are you able to fix the problem with the solution provided by Jose?

I assume that you are comparing the data by fetching from a table, if so, here is a sample.

If(ListRecords1.List.Current.DataDisplay.Column1=ListRecords1.List.Current.DataDisplay.Column2,
ListRecords1.List.Current.DataDisplay.Column1,
ListRecords1.List.Current.DataDisplay.Column1 +"-"+ListRecords1.List.Current.DataDisplay.Column2)

In this example i am comparing the data in 2 columns and showing the result based on your condition. Assuming that in the ELSE condition you want to show text from both columns by concatenating them. 

Let us know more details if you still didn't get the answers.

Shashank...

Hi,

Sorry for not providing a clearer view of my questions.

So basically my question is what Shashank have mentioned, i want to compare the data fetch from a table. 

For instance, the value is Yellow, Blue in column 1 and the value is Yellow in column 2, i want to display it as Yellow, Blue instead of Yellow,Blue, Yellow.

then i do not want to show two "Yellow" in the screen. that wise i want to compare the value in column 1 and column 2 to avoid duplicate value.

I will give it a try on both the solution provide. thanks

Hi Jace,

As I understand you need output like second table in following image

First table contain original data,

In first column of second table I just add expression

If(
Index(TableColor.List.Current.Color1,TableColor.List.Current.Color2) =-1,
TableColor.List.Current.Color1,
Replace(TableColor.List.Current.Color1,TableColor.List.Current.Color2,"")
)

It first check column2 value present in column1 or not, If not present show data as it is, if same contain found replace that content with empty string.

Let me know :)

Hi,

Please accept my apologies for not providing clear question.. Here exactly what i want to do.

From the table above, i need to concatenate values of column 1 and column 2. Currently it display in my screen as

I do not want to see duplicate value. It should display as Yellow, Blue instead Yellow,Blue,Yellow.

Thanks,

No problem jace ;)

To achieve this we just need to change on expression.

Delete second column of the second table

Add given expression in column1

If(
Index(TableColor.List.Current.Color1,TableColor.List.Current.Color2) =-1,
TableColor.List.Current.Color1+" "+ColorList.Current.Color2,
Replace(TableColor.List.Current.Color1,TableColor.List.Current.Color2,"")+" "+ColorList.Current.Color2
)

This is output

Please let me know, It solve your problem or not

Just to add to that, in case you have values like "yellow, blue" and "yellow, red" and you want to output "yellow, blue, red" you'll need a different, more complex approach. However, I'd probably take a step back and look at the reason for having comma seperated text in your tables at all. Sounds to me like you're having a data/database problem that you're trying to fix at display time.

Hi Jace,

Is it possible to have multiple color in column 2?

As Kilian said, my previous solution will not work if there is more than one colour in column 2.

Now,

You have Color1 & Color2 column and both column may have multiple colors, like

column1: Yellow, blue, Red

column2: Yellow, Pink, Blue

And you want All colour in single column like

Column1+Column2: Yellow, Blue, Red, Pink

I'm I right?

Hi,

Imho you should work on the problem. What I see is that your solution is a bandaid on the actual problem.

As I see it you can fix it much better inside the preparation and/or screen-action where you loop through the records and fix the columns

If you really think about it you could also possible fix it in the aggregate itself  (or use an advanced query)

Depends how the datamodel.

But the issue smells like you want to pivot data

Hello Jace,

Check attached oml file, that will solve your problem.

You can check output Here.

Let me know it work or not

Hi jace,

great solution   

But, in case you have values like 

"yellow, blue" and "yellow, red" 

and you want to output "yellow, blue, red"

will it work?