In the process of automating a workflow, I've needed files from certain directories in sharepoint, for which I've had to raise explicit access from the respective owners. But when a different user is running this workflow from sandbox, would they need to raise access for those directories as well ? I know they wouldn't be running this locally on their pc and that sandbox is hosted on cloud so I'm now aware of how access for this would work. Does this depend on how my company's IT department is set up?
... View more
Hi, I extracted the data from the various PDF files using alteryx PDF to Text tool and the parsed output is randomly spread in various rows. The data shown in the attached excel is the output generated from an Alteryx workflow. Column 1, Column 2, --- Column 6 are the values which contains the data values from the pdf file in an unstructured manner after we get the data from PDF to Text tool. It actually extracted the data by row wise present in the pdf file. I parsed the data in the actual columns now. But, got stuck in aligining the data to show without the null values for each pdf file. I need assistance in aligning the relevant file data of all the columns in a single row by removing the empty values and display the actual data in a single row for each pdf file. So, in total the output should be in 4 records. I tried to remove the nulls but, no luck. Kindly check the attached excel file and the workflow and help me with the solution. Row column, Column 1, Column 2, --- Column 6 are not required to show in the output. Thanks & Best regards, stj.
... View more
Hello I have two different regex asks (to be used in different tools of the workflow). 1. Firstly using Regex_Match, to filter out a strings which either start with a lowercase letter, or any word witin the string begins with a lowercase letter (e.g a lowercase letter after any space within the field). 2. To use Regex_Replace to remove any numbers/digits from within a string, and only leave the letters and special characters remain. Thanks for your help in advance Jay
... View more
As many Alteryx Designer users are already aware, there is an option to connect a tool to multiple tools at once by right clicking on it and selecting View Possible Connections. I would like to suggest an enhancement for this feature, which I think will make it even easier to connect multiple tools. Scenario 1 Suppose you drag & dropped many Append tools to existing connections as you realized you needed to add an extra information to your data. For example, a year input from a Text Input tool that is modified by the interface tool. If there were 30 Append tools, you would have to select all those available "ID - Append Fields S" checkboxes one by one. Scenario 2 You added multiple Input Data tools to canvas but don't want to select them individually to connect them to a single Union tool. Idea If there were a group checkbox for each tool category on each side (Output Connections and Input Connections), creating multiple connections would be as easy as clicking on the group checkbox on the Append Fields category on the Input Connections side (for Scenario 1) or clicking on the group checkbox for Input Data category on the Output Connections side (for Scenario 2).
... View more