Hey all,
There is already an option to clean up data in the results section - but it's limited to only the cleanups that the Cleanse tool used to do in the on-prem version.
Please could you use an inspection of the field to see what cleanup may be relevant?
For example:
A_B - there's no need to offer to clean up numbers - or perhaps just visually decrease that option
A_B - here the obvious cleanup is leading spaces
"A_B" - the obvious cleanup here is remove quotes
It seems that we can bring some smarts to this, since Alteryx AIDAN is AI enabled, to eliminate the toil of data cleansing.
When people ask what's so great about designer desktop, one of the simple things I mention is the record count. I think this would be a great addition to designer cloud. As an example, here's a pointless workflow in designer cloud:
Seems ok, but here's the same thing in desktop:
By just looking at the picture, you can see that I messed up my join and my 780 records have ballooned to 608,400. I can also see that I didn't have any unjoined records pretty easily. Designer cloud has this record count information when you click on each tool, but I think they should display the counts on the canvas like desktop.
Using Challenge 438 as an example, the crosstab in designer cloud needs to be dynamic for the new column names to ensure parity with desktop. Unless I'm missing something, you would need to click on the crosstab and manually reset it/add new fields anytime the data changes. Desktop would automatically pick up new fields.
Replace, ReplaceFirst, ReplaceChar and Regex_Replace in the cloud all have a limitation where arguments must be constants. Any attempt to use a column returns an error. This would a nice enhancement to have parity with Desktop. The below functions currently error out in cloud but work in desktop.
Replace(Column1,Column2, Column3)
Regex_Replace(Column1,Column2,Column3)
Could doesn't like that Column2 and Column3 are references to fields. It only works if you hardcode a string like "text". Desktop doesn't have this limitation.
Hi all,
When using the Sharepoint connector, using the Sites.Read.All permission on Service Principal does violate customer corporate security measures. The customer is requesting to implement certificate-based authentication for SharePoint Files. See ticket 00683632 for more information.
Thanks