Alteryx Community is the go-to hub for analytics professionals to learn, connect, and solve problems faster. Explore expert-led discussions, product resources, and best practices to build, automate, and scale your analytics workflows with Alteryx.
Hi i would like to check the number of leading spaces to determine the hierarchy , any idea how to get the leading spaces please? ValueLeading Spaces ABC3 A1B1C16 A2B2C26 A21B21C219 A22B22C229 DEF3 D1E1F16 D11E11F119
Have a workflow that generates a table render into an Excel sheet. This includes a column with a long list of manufacturing operations that still need to be completed, however when the table is generated the rows have "Wrap Text" enabled and it creates a very messy looking table. I want the rows to be the default height in…
Hello, Could you, please help me? I want to check the AR_ Name column in the Client column and keep the common matching text (50-60% matching ). Moreover, if inside the AR_ Name clients have a similar name and if they do not match at all with the Client column, should return the AR_ Name. This should be applicable only for…
Hello - thanks for the help in advance. I have cells that follow this format: qual RES1 'Restaurant' = 'Five Guys/Burger {US}' qual GY1 'Gym' = 'Planet Fitness' qual LOC1 'Location' = 'New York/{Bronx, Brooklyn}' concept 'Example 1' where 'School' = 'Syracuse University' and RES1 and 'Meal Type' = 'Dinner' concept 'Example…
I have a schedule that, at the end of each month, two fields will be added to this schedule with the field names starting with "Current_Month_End_Date + Amount A" and "Current Month End Date+Amount_B". Please see screen shot 1. Therefore, by the end of 2026, this file will essentially contain Amount A and Amount B fields…
I ran into this issue when a co-worker was having trouble with the Round() expression in the formula tool. After some research on the community, I found the reason, which seems to be how Alteryx stores the values in a binary format. There was a pretty complicated explanation of why that you can see here if you really want…
I have data for employees working on different projects as in the below example where A,B,C,D,E,& F represents projects. Employee IDABCDEF1YesYes 2 YesYes 3Yes Yes Yes4 Yes 5 Yes I want to add a new column in which all the projects assigned to a employee will be consolidated separated by a comma. Something like in the…
I have a name field which contain a mixture of strings and numbers. Unfortunately, some of the strings are written in formats that triggers excel and alteryx to believe that they are scientific notation. E.g. 1E05. Simply adding an apostrophe to the beginning of the cell does not prevent this as the data come out of the…
Hello, Could you, please help me with the situation below: How can I, extract the invoice number, which starts with S0 and keep only the invoice number - Ex. S0001 00008761. I should mention that i can find more invoice numbers, into a line and sometime the invoice number might not respect all the number length.…
Hi I have used the formula tool and can replace any field with e.g the word hello the goodbye I use replace (column name) "hello" "goodbye" But i also want to replace other words in the same column - such as "wave" to be replaced by "clap" I am stuck as to how and i have tried several options Thank you in advance
It looks like you're new here. Sign in or register to get started.
