Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
Please help me to add new field D, which contain result from A, B, C. (simple way)
See below picture
Thanks,
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.
use
in expression
alt(A,B,C) in Expression
Yes, thanks.
I was tired. I used insted of & +.
Happens
In my case in the second row I have double answer. I need to use it only one of them.
???
So you can use A & ' ' & B & ' ' & C as D so you don't omit any value.
Regards.
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
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.
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.