Example
Assume you have an Alteryx workflow that uses the FindNearest tool that tells you the shortest distance between two venues. After you import your workflow and click the Validate button, you get the following error in the Validation Summary dialog:ClosestVenue.
You can still click Transpile, but you notice that in your bundle overview, there is a Failed status for this components row. When you open your pipeline, you see a todo gem in place of the FindNearest tool.
Solution
-
Open your bundle and navigate to your transpiled pipeline.
Notice the gem that isn’t supported is a todo gem.
The Transpiler automatically creates a todo gem for unsupported Alteryx tools. -
Open and update the todo gem.
Implement the logic for that Alteryx tool in one of the following ways:
- Use a combination of Prophecy gems
- Write your custom script in the Script gem
- Write your custom SQL statement in the SQLStatement gem
- Create a new gem using the Gem Builder for SQL