The Inspire Pin contest has begun! Win a free pass to Inspire by submitting your design to be made into a real-life pin! Submission details can be found here.
It would be great if you could overwrite an existing workflow when saving to the gallery from designer. It could be a simple popup with a yes/no option to overwrite/save a new copy. Currently, you would have to 1) Save your workflow to the Gallery. 2) Click on ok and be taken to that workflow. 3) Go back to your private studio. 4) Search for the app you want to replace. 5) Realize you have 7 copies of the same workflow with the same name and try to determine which one you want to replace. (this could just be a "me" problem) 6) Select that app 7) Click on replace workflow. π type the name of the workflow in the box. 9) Look through your list of 7 workflows and choose the one that was just uploaded. Usually the first in the list I think. 10) Lament that it took way too many steps. I recognize that you can open workflows from the gallery in designer which does allow overwriting, but I've run into issues with 1) external dependencies not working as expected (ie packaged assets don't quite work the way I want) and 2) about half the time it will simply give you root errors and then your only option is to save to a folder and then go through the process above.
... View more
Currently, FileGetExt returns the file extension including the Excel sheet name if present, e.g., FileGetExt("filename.xlsx|||`Sheetname$`") returns ".xlsx|||`Sheetname$`". In many cases, the pure file extension is needed, and removing the sheet name is not always trivial (because it is sometimes separated by "|", sometimes by "|||"). Proposal: Extend FileGetExt by an additional optional parameter "OmitSheet". Add a new command FileGetSheet with optional parameter "CleanUpSheet". FileGetExt("filename.xlsx|||`Sheetname$`") β ".xlsx|||`Sheetname$`"
FileGetExt("filename.xlsx|||`Sheetname$`", 0) β ".xlsx|||`Sheetname$`"
FileGetExt("filename.xlsx|||`Sheetname$`", 1) β ".xlsx"
FileGetSheet("filename.xlsx|||`Sheetname$`") β "`Sheetname$`"
FileGetSheet("filename.xlsx|||`Sheetname$`", 0) β "`Sheetname$`"
FileGetSheet("filename.xlsx|||`Sheetname$`", 1) β "Sheetname"
FileGetSheet("filename.yxdb) β "" or Null() This way, the default behaviour would be unchanged to preserve backwards compatibility. The extension and new command would make handling of Excel filenames much easier.
... View more
Alteryx Designer does not visually mark a workflow on the canvas as βpublished.β When you open a workflow in Designer, it looks the same whether it came from Gallery or is just a local file β there is no icon, banner, colour, or flag on the canvas to distinguish it. If I have 2 wfs opens (Gallery, Local File), the canvas looks the same. The only way to spot the difference is hovering over the name. Recommendation, add something before the WF name in the canvas. (In the images below, I had to change the WF name to avoid confusion) Picture 1 Before (1st wf is the published one) β β Picture 2 Suggestion (World con / Shaded Triangle / My picture :)) to differentiate it (1st wf is the published one) β β
... View more