topic Re: Merging two rows in Alteryx Designer Desktop Discussions

Merging two rows

Ekta — Wed, 24 Nov 2021 03:55:14 GMT

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

Re: Merging two rows

Rupal03 — Wed, 24 Nov 2021 04:53:48 GMT

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.

Re: Merging two rows

Ekta — Wed, 24 Nov 2021 14:14:21 GMT

@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

Re: Merging two rows

afv2688 — Wed, 24 Nov 2021 14:54:56 GMT

Hello @Ekta ,

would this work for you?

Regards

Re: Merging two rows

Matthew — Wed, 24 Nov 2021 15:03:24 GMT

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

@afv2688's method also works

Re: Merging two rows

Ekta — Wed, 24 Nov 2021 15:07:36 GMT

@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,

thanks so much in advance

Re: Merging two rows

Matthew — Wed, 24 Nov 2021 15:16:09 GMT

how about this

Re: Merging two rows

afv2688 — Wed, 24 Nov 2021 15:35:29 GMT

Hello @Ekta ,

how like this?

Regards

Re: Merging two rows

HomesickSurfer — Wed, 24 Nov 2021 15:57:23 GMT

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

Re: Merging two rows

danilang — Sun, 28 Nov 2021 13:44:47 GMT

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

Re: Merging two rows

Ekta — Wed, 26 Jan 2022 02:06:23 GMT

Thank you Dan for the suggestion , this text was extracted from a Pdf and was not extracted correctly. After fixing the input file, it worked.

Regards,

Ekta