Combine 2 or more field in 1

[Anonymous]

Hi there,

Please help me to add new field D, which contain result from A, B, C. (simple way)

See below picture

Thanks,

[Anonymous]

In script:

A & B & C as D, but if in some cases, you have two columns with data, you must do A & ' ' & B & ' ' & C as D.

I hope this helps.

Regards.

[SunilChauhan]

use

in expression 

alt(A,B,C)  in Expression

[Anonymous]

Yes, thanks.

I was tired. I used insted of & +.

Happens

[Anonymous]

In my case in the second row I have double answer. I need to use it only one of them.

[Anonymous]

???

[Anonymous]

So you can use A & ' ' & B & ' ' & C as D so you don't omit any value.

Regards.

[Anonymous]

Thanks for reply,

When I use A&''&B or A&' '&B, I get wrong result.

I checked I have only 1 time, where double answer.

I think I need to use condition

like If(ID=111 and B='this week', '', B) as B

,

Regards

[Anonymous]

I'm sorry, but I didn't understand you.

When you got two values, are the same values or differents?

If are differents, I think you want show both, else you must try with "if", I mean if(A=B=C, A, if(A=B, A,...)) as D in the script. It's some tedious, but it works.

Regards.

[Anonymous]

It should be one value in one of 3 fields or all of them empty.

But some reason I see double value in 1 row. I want to remove one value from one field.

I like your idea. But not in my case.