Hello, I want to group column "ID" and retains only rows which has min date as shown in output. Can anyone assist on this Input Account ID date branch status Country 1234566 100 4/20/2024 ABC Suspend USA 1234567 100 4/15/2000 CDE Cancel USA 1234570 100 4/26/2022 FGH Cancel USA 1234561 100 4/26/2001 IJK Cancel USA 789 200 4/26/2024 FADAS Cancel UK 789 200 4/26/2024 ASDFA Complete UK 789 200 4/20/2023 ERGQ Complete UK 789 200 4/26/2022 FAAFD Complete UK Output Account ID date branch status Country 1234567 100 4/15/2000 CDE Cancel USA 789 200 4/26/2022 FAAFD Complete UK
... View more
Hi guys, I have a PDF table (attached) and I would like to extract it into Excel for further analysis. I used the PDF to Text and selected Alteryx Table as output option, but it doesn't give me the result that I want. I wonder if there is better way to extract PDF table information in Excel. The ideal Excel template: Related Scope Current year 2012 Public Sector Private Sector Others Overall Opinion NI S NI NI Control Environment S S S S Lorem ipsum Lorum ipsum Lorum ipsum S U N/A N/A
... View more
Hello, I am still at the early stage of using Alteryx designer, and I'm not if Alteryx can do this - I have a pdf file and I've extracted it to excel. Now I have a key words file, containing all the key words that I would like to use to match against the excel - see below table: Main Category Sub Category Areas Keywords (English) Data Awareness Training & Communication data related training Data Awareness Training & Communication data related communication Data Awareness Training & Communication data related awareness Data Awareness Training & Communication Data awareness Data Awareness Training & Communication Data training & awareness Data Awareness Training & Communication Training and Awareness So, the idea is whenever the keywords (in the keywords column) appear, then it would automatic show the sub category areas and main category. See the output columns below: Output Output Description Results Conclusion Main Category Sub Category Areas Perform a walkthrough to understand if management has implemented data related communication to the 3rd party vendors, and data related awareness has been acknowledged by the employees We performed a walkthrough with management, based on the walkthrough and the supporting provided. We confirmed that management has implemented data related communication to the 3rd party vendors, and data related awareness has been acknowledged by the employees Satisfactory Data Awareness Training & Communication
... View more
Hello, I would like to use the Input Data tool to pull tables in an excel file into my workflow. Can someone please assist? I have attached a copy of the excel file that I am referencing. Inside the file there are 2 tables titled "PNC_Transaction_Detail" and "SVB_Transaction_Detail". I'd like to bring the data within both of these tables into my workflow. Best, Ryan
... View more