Happy 8th birthday to the Maveryx Community! Take a walk down memory lane in our birthday blog, and don't miss out on the awesome birthday present that all Maveryx Community members get to take advantage of!
alteryx Community

Alteryx Designer Desktop Discussions

Merging two rows

8 - Asteroid

Hello everyone,

I am stuck at a point in my workflow and need your kind help, please help me with the formula to combine two rows.

Input-

 Field 1 by: 01 Nov 2021.

Output -

 Field 1 01 Nov 2021

Thank you so much in advance

10 REPLIES 10
8 - Asteroid

Hi @Ekta

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.

8 - Asteroid

@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

16 - Nebula

Hello @Ekta ,

would this work for you?

Regards

11 - Bolide

you can use the crosstab tool to bring them onto the same row and concatenate

@afv2688's method also works

8 - Asteroid

@afv2688 Thanks so much , this is perfectly working fine - Can i also check please lets say if we have more values

Field 1

ABC

QWERTY
by: 01
Nov 2021.

and required output is -

Field 1

ABC

QWERTY

01 Nov 2021

How can we modify the WF please,

11 - Bolide

16 - Nebula

Hello @Ekta ,

how like this?

Regards

12 - Quasar

Hi @Ekta

Keep it simple:

``IF StartsWith([Row-1:Field 1], 'by:') THEN Right([Row-1:Field 1], 2)+" "+TrimRight([Field 1],'.') ELSE [Field 1] ENDIF``
18 - Pollux

hi @Ekta

The various solutions provided here work, but you may need to look earlier in your workflow to find why you end up with this

 Field 1 by: 01 Nov 2021.

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?

Dan

Labels