Looking for Starter Kits? Head to the Community Gallery! Now formatted as YXIs for easy installation.
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