Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Merging two rows

Ekta
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
Rupal03
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.

 

Rupal03_0-1637729505779.png

 

Ekta
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

afv2688
16 - Nebula
16 - Nebula

Hello @Ekta ,

 

would this work for you?

 

Regards

Matthew
11 - Bolide

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

 

@afv2688's method also works

 

NothingButThyme_0-1637766029257.png

 

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

thanks so much in advance

Matthew
11 - Bolide

how about this

 

NothingButThyme_0-1637766957117.png

 

afv2688
16 - Nebula
16 - Nebula

Hello @Ekta ,

 

how like this?

 

Untitled.png

 

Regards

HomesickSurfer
12 - Quasar

Hi @Ekta 

 

Keep it simple:

 

HomesickSurfer_0-1637769406143.png

IF StartsWith([Row-1:Field 1], 'by:') THEN Right([Row-1:Field 1], 2)+" "+TrimRight([Field 1],'.') ELSE [Field 1] ENDIF
danilang
19 - Altair
19 - Altair

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