Welcome to the Gallery. Please feel free to post and comment, and check out our FAQ!

Community Gallery

Post, download, and share all of your favorite tools and workflows — from Alteryx supported to user-built.
Introducing Alteryx Marketplace

Easily access verified, supported, and secure Add-Ons.

LEARN MORE
Comments
Ar13f
10 - Fireball

Dear @NicoleJohnson 

 

ask permission to bookmark this article ...

Qiu
20 - Arcturus
20 - Arcturus

@NicoleJohnson 
Maybe I missed it, but can we have a direct link?
There is a download button😁, So sorry.

NicoleJohnson
ACE Emeritus
ACE Emeritus

@Ar13f  You should be able to bookmark by clicking on the link shown below:

 

NicoleJohnson_0-1640017030133.png

 

And @Qiu glad you found it 🙂 Cheers!

NJ

 

Qiu
20 - Arcturus
20 - Arcturus

@NicoleJohnson 
Bookmark done. Thanks

Ar13f
10 - Fireball

Dear @NicoleJohnson 

 

Bookmark done. Thanks

ejhaley
8 - Asteroid
8 - Asteroid

Hi All and @NicoleJohnson,

 

I love this macro and have been using it for some time.  I was trying to run this macro with a dataset from a new source (different than the source I've used previously).  It runs perfectly when used with data from the old source, but when used with data from the new source it will spin for a while and then return nothing in the output (no errors or anything, just no records returned, and yes I have checked that hierarchies do actually exist in the new source :P)

 

I've attached screenshots below, unfortunately I can't attach my workflow example here (I suppose my account isn't a high enough level to post files).

 

Screenshot (1) - Shows input of 'Example 1' Container [new source].

- Checked data types and set to V_String

- Removed duplicates on Children (Emp ID)

- Removed data quality issues (i.e. non-CEO nulls) in Parent (Supv ID)

 

Screenshot (2) - Shows input of 'Example 2' Container [old source].

- Checked data types and set to V_String

- Removed duplicates on Children (Emp ID)

 

Screenshot (3) - Shows output of 'Example 1' Container [new source]

- No records were outputted

 

Screenshot (4) - Shows output of 'Example 2' Container [old source]

- Expected output

 

Any help would be greatly appreciated! :)

 

(1)(1) Example_1_Screenshot.png

---------------------------------------------------------------

(2)ejhaley_0-1681407528007.png

---------------------------------------------------------------

(3)ejhaley_1-1681407598336.png

---------------------------------------------------------------

(4)ejhaley_2-1681407657690.png