Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

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

Multi row tool

Tid14
8 - Asteroid

Hi, 

I am having doubt in applying one of the expression using multi row tool where I need to take the value given in 2nd row of “Reference part numbers 2” column in 1st row.

Any help on this?

 

3D50450D-9F0F-4604-B87F-D088C136BF00.jpeg

5 REPLIES 5
Qiu
21 - Polaris
21 - Polaris

@Tid14 
I think it is just the case shown in the sample flow of Multi-row Formula tool?

2024-05-23 115122.png

Tid14
8 - Asteroid

E1B00000-CE24-4E25-82E6-5A897C26045B.jpeg


it shows this error

Qiu
21 - Polaris
21 - Polaris

@Tid14 
This error most likely indicates that you have not named your new column.
If you can upload you sample flow, we can take a look.

Raj
16 - Nebula

@Tid14using multi row formula 
1 -update the original field
2- formula - IF IsNull([Reference Part Number 2])
THEN [Row+1:Reference Part Number 2]
ELSE [Reference Part Number 2]
ENDIF

hope this helps.

terry10
12 - Quasar

Do you have "Update Existing Field" checked?

 

a.PNG

Labels
Top Solution Authors