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.
Hello Alteryx Experts! I know you will be able to help me find a solution to my issue. I have very dirty data, very dirty data! But there is hope at the end of the tunnel. I have a text field where I need to extract 3 numbers which occur together. Th first number will always be preceded with an "S", the next number by "O"…
I would like to extract 6 digit number from each row , each should start with reporting and rows have trailing spaces DATA REPORTING FOR: 1000035909 ABCD BANK MIPPL INTERNATIONAL SETTLEMENT SERVICE PROC DATE:10AUG25 REPORTING FOR: 100003570 ABCD BANK MIPPL INTERNATIONAL SETTLEMENT SERVICE PROC DATE:10AUG26 REPORTING FOR:…
Hello Professionals, I'd want to thank all professionals who helped me when I was stuck while studying for Alteryx Designer Core. I'm unsure if the next step is Alteryx Designer Advanced, but I'd like to continue learning more about Alteryx. Any advice and instructions on what sources to learn and practice is very much…
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…
How do I remove invalid characters from an Excel filename using RegEx. I.E. I don't understand how to populate the Regular Expression field. Thank you. Brian
I'm struggling with splitting string in two parts by delimiter, which is a dash ("-"): "sample part 1-sample part 2" The problem is that sometimes the text contains a dash (and should be split into two new fields, Say "Output 1" and "Output 2"), sometimes not which means that there is no Output 2 and that field should be…
My current Python Code : (\<Shares|\<Shares\:|[^\-]Share\:|\<Underlying Share\:|\<Exchange|\<Exchange\:)\s\s\s\s+([[:alpha:]|\s|\-]+)\s I'm looking to extract the following : 1. Share Name [Share / Shares / Shares: ] 2. Ticker Code [ REUTERS : / Bloomberg Ticker: / Bloomberg Code: / Reuters Code: / RIC: / Bloomberg: ] 3.…
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 am trying to make column A to column B.
Hi I have a long list of unstructured data. In the first instance I need to extract the email addresses that are populated into a new column. After using a text to column with Space as the delimiter I tried the following - IF Contains('@', [MAILING / BANKING INSTRUCTIONS1]) THEN [MAILING / BANKING INSTRUCTIONS1] ELSE ""…
It looks like you're new here. Sign in or register to get started.
