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.
Good evening everyone. Was hoping i could get ideas, or maybe steer me in the right direction, on how to build the below (see screenshot). I have a numeric field called AMOUNT and i need to be able to create a new field that spells out whatever is in the AMOUNT field. Is there a tool that will do that? Asked Chatgpt and it…
A solution to last week's Challenge has been posted HERE! I learned the worst thing to say to a bunch of football fans: "The Super Bowl? It's just another football game". The looks of horror on my colleagues' faces when I said that are burned into my memory forever. And let me warn you: don't say that when you have…
A solution to last week's Challenge has been posted here. I loved seeing the variety of solutions that our Challengers came up with! Admittedly, my solution probably has more tools than it should but it gets the job done...with only one Join tool! In the spirit of friendly competition, especially with the self-imposed…
Hello Community!!! I am building a solution which is divided in 3 parts Part 1 : Getting daily reports in which below Accounts counts should update against Input Transaction TypeAccountsProcessorMol3420JyotiMol0219JyotiMol0110AishwaryaMol092AishwaryaS1013Aishwarya Output : here MOL34 = STP V, MOL02 = Existing User and so…
Hi folks, We have a system that allows the user to add a file mark to a claim based on the work thats being comlpeted. When looking at the data a claim is duplicated many times depending on the amount of file marks. In the attached data I'm looking to combine the file marks into a single field so that each of my claims can…
This week let’s have some fun and look at predicting baseball wins. For those looking for the solution to last week’s (challenge #17) the link is HERE. The use case: The Baseball season has completed and it's time to project next year's win totals. The objective: Determine the top 10 variables that correlate to wins…
Hi Folks, I'm getting some inconsistent results when attempting to extract names from within a field that can contain between 1 and 100 values. I've been using the contains function: Contains([name field], 'Russell') Or Contains([name field], 'RUSSELL'). When I go over to SQL I'm using the function iLike: ILIKE '%Russell%'…
I have a schedule I need to transpose with a lot of data. Any tips, tried transpose but was unsuccessful.
I hope you all had fun with last week’s challenge, completing lap one form the Inspire 2016 Grand Prix event (challenge #29). The solution is posted HERE. Now that you have your data prepped it is time for Race 1 lap 2, you need to answer some questions so you will have content for your annual "Draft Recap" newsletter.…
Hi Community - In the sample excel, I have a few lines of the same invoice. I want to summarise it together into a single line with the Tax Rate as SGST and CGST coming under two columns. I tried using summarise and cross tab, but it is coming into two lines instead of one. Can someone please help?
It looks like you're new here. Sign in or register to get started.
