In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

Merge row need to be seperate line

Maheshp
8 - Asteroid

Hi Team,

 

As per below screen shot, you can see the Batch ID which has been merged between 5 rows, is there any way where we can get in each and every row. 

 

Batch IDFunding Account NameReport IDAmount
ad2f78af-bd1c-4786-9cf0-aa2bf81fce92JWS UK JPM EUR1239,092.84
3431,238.56
324520
2452,061.73
5673,059.6

 

We want the data like below.

 

Batch IDFunding Account NameReport IDAmount
ad2f78af-bd1c-4786-9cf0-aa2bf81fce92JWS UK JPM EUR1239,092.84
ad2f78af-bd1c-4786-9cf0-aa2bf81fce92JWS UK JPM EUR3431,238.56
ad2f78af-bd1c-4786-9cf0-aa2bf81fce92JWS UK JPM EUR324520
ad2f78af-bd1c-4786-9cf0-aa2bf81fce92JWS UK JPM EUR2452,061.73
ad2f78af-bd1c-4786-9cf0-aa2bf81fce92JWS UK JPM EUR5673,059.6

 

Regards,

Mahesh

 

 

 

5 REPLIES 5
Maheshp
8 - Asteroid

Also attached the file.

OTrieger
13 - Pulsar

@Maheshp 

One way to do it is by using Multi Row Formula to get the text into the blank rows. I can see that in Alteryx all the data is sitting correctly in the correct column therefore no additional action is needed.

Maheshp
8 - Asteroid

Can we see the example, as i am doing but it is not working.

OTrieger
13 - Pulsar

You will need to use IF formula

IF [Field]=Null() AND  [Row-1:Field]!=Null() THEN  [Row-1:Field] ELSE  [Field] ENDIF

If does not work then share a screen on what do you see and which error do you get if you get any

Swathi
9 - Comet

PFA  @Maheshp for the solution

Please mark as solution if you are happy

Labels
Top Solution Authors