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.
SOLVED

How can I get the desired output? (Group by and Fill Down)

HW1
9 - Comet

This is tricky for me.

I need to fill down a set of values. There is only 1 value per [File]

How can I get it?

I tried summary tool and then sort down however I am unable to get it absolutely correctly.

 

Current example dataframe:

 

RecordIDFileRegExOut1
143911.pdf 
143921.pdf574252
143931.pdf 
143941.pdf 
143951.pdf 
143961.pdf 
143971.pdf 
143981.pdf574252
143991.pdf 
144001.pdf 
144012.pdf 
144022.pdf 
144032.pdf 
144042.pdf 
144052.pdf574578

 

Expected dataframe/output:

 

RecordIDFileRegExOut1
143911.pdf 
143921.pdf574252
143931.pdf574252
143941.pdf574252
143951.pdf574252
143961.pdf574252
143971.pdf574252
143981.pdf574252
143991.pdf574252
144001.pdf574252
144012.pdf574578
144022.pdf574578
144032.pdf574578
144042.pdf574578
144052.pdf574578

 

How can I create a workflow to get here?

4 REPLIES 4
Qiu
20 - Arcturus
20 - Arcturus

@HW1 
Why the value for "14391" is empty? 😁

HW1
9 - Comet

That's cause after parsing the PDF, the value appears at the second row in "this example".

Its not necessary that the first row has to be blank.. it can be filled.

However, I figured out (discovered 😁) that sort can be by multiple columns hence grouping and then filling down.

Qiu
20 - Arcturus
20 - Arcturus

@HW1 
I hope my interpretion is correct.

0524-HW1.PNG

Qiu
20 - Arcturus
20 - Arcturus

@HW1 
Thank you for the accept mark, even though you have figured out by yourself. 😁

Labels