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.
Comments
albert_alaluf
9 - Comet

Hi @EmilyVA 

 

Alteryx always is providing new tools and surprises. Can you please elaborate a little bit more?

Albert

EmilyVA
Alteryx
Alteryx

@albert_alaluf This is a placeholder spot for now... more will be revealed at Inspire 2023 in a few weeks!

albert_alaluf
9 - Comet

This is not fair :-)

Now you say we should wait until Inspire.... I'm assuming this will be part of v2023.1 or something really different....

balders-ie
7 - Meteor

Hi this looks really cool, but I cannot get it to work. 

 

When I add it to a workflow and run the workflow I get this error from the tool:

 

Error: Workflow Summary (34): <class 'AttributeError'>: 'NoneType' object has no attribute 'string'

 

 

EmilyVA
Alteryx
Alteryx

Usually that error means I haven't gotten my DCM configured yet.  There’s help for that here:

   https://community.alteryx.com/t5/Data-Science/How-To-Use-the-Workflow-Summary-Tool/ba-p/1122280

oyes704
6 - Meteoroid

Best Sneak Peak by far!! Emily, I love your ideas every years!

VizChic
11 - Bolide

@EmilyVA  - can you please share what information gets passed to the API? e.g. would it include text inputs or data, or is it only metadata? Thanks, Fi 

acarter881
12 - Quasar
EmilyVA
Alteryx
Alteryx

Thanks, @acarter881 - couldn't have said it better, myself!   @VizChic hope that helps!

trung2403
8 - Asteroid

I got this error. Anyone knows how to fix it? Thanks

trung2403_0-1685496546747.png

 

VizChic
11 - Bolide

Thanks @EmilyVA & @acarter881 

acarter881
12 - Quasar

@trung2403 which version of Designer do you have? That error looks like a Python SDK error (The latest version of protobuf package (version 4.21.x) is incompatible with the SDK) that is shown in this community post: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Knowledge-Base/Error-quot-Internal-error-F...

 

EmilyVA
Alteryx
Alteryx

@acarter881 and @trung2403 I agree that looks like an SDK error, but the Workflow Summary tool is on the Python SDK version 2.2.0,  so I'm not sure the community post linked will help with the solution.   The best guidance I've gotten from our Python SDK team is:

1. Try removing the .shiv folder from your home directory and re-installing the tool the yxi  (this will be regenerated the first time the tool runs, which might make it a bit slower but shouldn't break anything)

2. Try deleting the tool (either from C:\Users\YOURUSERNAME\AppData\Roaming\Alteryx\Tools or from C:\ProgramData\Alteryx\Tools , depending on whether you installed for yourself or for everyone)  and reinstalling it from the yxi 

3. If you have admin permissions, try installing the tool for all users, not just yourself (it may help to open Designer in admin mode to do this).

 

Based on some internal troubleshooting with someone on our team, beyond those two steps, it seems like the issue may relate to the network settings on the computer, and we're still working on approaches to help y'all diagnose those issues and fix them.

Brinker
8 - Asteroid

What is the oldest version of Alteryx this is compatible with?

EmilyVA
Alteryx
Alteryx

@Brinker The Workflow Summary tool was created using the Alteryx Python SDK v2 which is compatible with all Alteryx Designer Desktop releases starting with 2021.4.

EmilyVA
Alteryx
Alteryx

Thanks to everyone who's downloaded this tool and given it a shot in the last few weeks!  And special thanks to everyone who has shared feedback, here or on either of the blog posts linked above!

 

Today we're updating the tool from the initial version 1.0 to version 1.1.0.  The new version incorporates the following updates:

  • removing OpenAI cost estimates from the tool's Messages (OpenAI's pricing changes too rapidly for us to keep up!  They've already changed it in the month since the Workflow Summary tool's initial release, so the estimates we were providing are now incorrect.)
  • adding an output column for total Tokens Used for each workflow summary
    • to estimate the cost for each workflow summary, look up the current OpenAI pricing per thousand tokens used for the Chat gpt-3.5-turbo (4k context) model. Then use the formula:

[Tokens Used] / 1000 * [Price per thousand tokens]

 

  • adding a Formatted Summary output column with html-formatted combination of workflow name, Topic, Headline, and Summary that can be easily viewed using the Report tab of a Browse tool
  • improved error handling

To get the new version of the tool, just click the Download button and install the new yxi.   Please keep the feedback coming!

ht1001
5 - Atom

@EmilyVA, I'm using Alteryx 2023.1.1.200 and it keeps crashing my Alteryx. Have you experienced anything similar?

EmilyVA
Alteryx
Alteryx

@ht1001 I have not, and I am very sorry to hear it is doing so for you!  Does it throw any errors when that happens?   

KojiIzawa
Alteryx
Alteryx

Thanks for sharing this. It's very cool! One question, can I configure to let OpenAI API respond in Japanese?

EmilyVA
Alteryx
Alteryx

Hi @KojiIzawa  - thanks for giving the tool a try!  Selecting an output language is not currently an option, but is a great suggestion that I'll add to the bucket of ideas for future improvements!

KojiIzawa
Alteryx
Alteryx

Thanks Emily VA, I hope to have this soon!!

Hiblet
10 - Fireball

I have used this tool for a task where we have been given some analytic apps and macros, and been asked to document them.  It has given us good insight into how the components all fit together, but it seems to fall down on very large and very complex flows, which is understandable.  The tool seems to go into an infinite loop.  I have attached a snapshot below of the tool just entering the infinite loop, and it bleeps back the same line multiples times per second.

 

I am a little concerned that it is busy sending stuff to OpenAI on my key at this point, which might be causing me a charge - not a big problem if caught, but if the tool was unattended, might splurge a load of tokens for no good result?  If it is not spamming OpenAI then fine, but I would have to sniff the traffic to see that happening.

 

Any how, I would love to help Alteryx get this fixed.  The problem is reproducible on demand.  I can do a Teams session and demo it to support if needs be.  I am using 2023.1.1.200, and downloaded the Workflow Summary package today (26th Sep 2023).

 

 

WorkflowSummary_Looping.png

 

Thanks! S.

EmilyVA
Alteryx
Alteryx

Hi @Hiblet - thanks for sharing this!   It's great to hear that the Workflow Summary tool was useful!  (At least until it choked on the Very Long Workflow.)

OpenAI is NOT being pinged every time you get that message - I'm confident that if you scrolled all the way right or copied the message and put it into notepad or some other editor with word wrap, at the end you'd see that the text concludes with "is too long for ChatGPT summary.",   which is a message that's written out *instead* of calling OpenAI if the single tool is too long for it to summarize.

 

Is the text in that error message ("ToolContainer is a tool in Alteryx that acts as a container for other tools.  In this specific configuration, the container is named "Rebalances" and it contains multiple tools...") part of the original text in the workflow, or the result of the earlier steps in Workflow Summary trying to summarize individual tools?

 

If you'd like a quick work-around, I'd suggest making a copy of the workflows in question (I agree- that initial token count is impressively long!) and trying a couple things: 

1. if the text in the error message is in the original workflow, try hand-summarizing just that particular block of text down to something that's less than about 3500 tokens when pasted into the OpenAI tokenizer (OpenAI Platform).  (Workflow Summary currently doesn't have any work-arounds for a single tool being too big to summarize, which can happen if a very long text block is present.)

2. If the text in the error message is NOT in the original workflow, I'd suggest pulling the tools inside that container out of the container temporarily to see if that helps break the logjam in the logic.

 

I'll PM you to follow up on details of this particular workflow. 

Hiblet
10 - Fireball

Good to know that OpenAI is not being spammed, that is a relief.  Picking up the PM, thanks for the assistance!