I am stuck at a point in my workflow and need your kind help, please help me with the formula to combine two rows.
Thank you so much in advance
The solution is really simple. You simply have to join the two fields by a "+" sign and you will get your desired result. I am attaching the screenshot for your reference.
@Rupal03 Thank you for your reply, but my values are in same column and 2 different rows , and i want to combine them together. Possible if you can help me with the formula please
Hello @Ekta ,
would this work for you?
you can use the crosstab tool to bring them onto the same row and concatenate
@afv2688's method also works
@afv2688 Thanks so much , this is perfectly working fine - Can i also check please lets say if we have more values
QWERTYby: 01Nov 2021.
and required output is -
01 Nov 2021
How can we modify the WF please,
thanks so much in advance
how about this
how like this?
Keep it simple:
IF StartsWith([Row-1:Field 1], 'by:') THEN Right([Row-1:Field 1], 2)+" "+TrimRight([Field 1],'.') ELSE [Field 1] ENDIF
The various solutions provided here work, but you may need to look earlier in your workflow to find why you end up with this
Is this in your input data, or is does your input data look like "Field 1 by: 01 Nov 2021." and you're trying to split the fields?