Hello, I'm trying to run .bat files in Alteryx Designer and am running into errors. I'm able to run the .bat command in a powershell window outside of Alteryx so I know the command is accurate and without typos. I checked where Alteryx was downloaded on my machine and it's where it's supposed to be which is here C:\Users\[User]\AppData\Local\Alteryx. There's plenty of articles on the community about Powershell issues but I still haven't come across a solution that worked for me. I attached my workflow if anyone is able to replicate my issues. You'll just have to put your file path where it says "[Your File Path Here]" in the formula tool. System Setup: Version: 2022.1.1.42725 Type: Non-Admin AMP Engine: Off Operating System: Windows
... View more
What is the best way to pull data from certain columns based upon a specifics within another column - attached is my output sample. 1) I am trying to recreate a "Table" in alteryx, essentially doing a lookup on columns F6-K6 using data from the "E" column. 2) My Excel has =IF(ISNUMBER(FIND($E$10,$G$6)),"-","NOT APPLICABLE") as well Style (Keep Blank if app) MOD MOD MOD MOD Department Fabric Sourcing Production Tailoring Customer Service Dispatch Owner Ryan Ryan Ryan Ryan Ryan Secondary Owner Pearl Pearl Pearl Pearl Pearl Fabric Check Cotton Denim Organza Cotton Silk Fabric Cotton/Silk Denim Cotton/Denim/Organza/Silk Cotton Cotton/Denim/Organza/Silk Completed by OrderID Name Cost Style Fabric 3 1 5 2 5 747380 Kevin 1500 Tops Cotton - NOT APPLICABLE - - - 747896 Mark 1500 Tops Denim NOT APPLICABLE - - NOT APPLICABLE - 787985 Mary 1000 Tops Organza NOT APPLICABLE NOT APPLICABLE - NOT APPLICABLE - 759876 Rose 1000 Bottoms Cotton - NOT APPLICABLE - - - 758964 John 2000 Bottoms Silk - NOT APPLICABLE - NOT APPLICABLE -
... View more
Hi all, I am facing a issue in adjusting column headers of different files, the headers are same ex- Name column but the same headers are different for different files ex. NAME, name. Therefore while consolidating the data I get multiple columns. Kindly guide me the steps so that I can create an output. Below I am attaching the data and this is what I want to achieve as shown in the Image. Kindly Support.
... View more
Hello Experts, I have 100,000 +rows of excel data that needs to be parsed into rows and columns. To distinguish data in the rows - it is indicated by page numbers (ex: page 1 of 700). Below is the input data and the expected output: Page 25 of 700 EffDt <= 4 day RULE NAME Left Right Criteria = 1 Criteria = 1 ( Column Op Value ) Logical ( Column Op Value ) Logical Debit or = C AND Debit or = D AND Credit Credit Reference 4 = 856 Reference 4 = 859 Left Match Group Right Match Group Tolerance Tolerance effectiveDate Left Item Additional Op Right Item Additional Tolerance Info (L) Info (R) Effective DateYYYYMMDD <= Effective Date YYYYMMDD 4 Days No Exception Combo Rule status Page 26 of 700 Many DR Contract # MATCH RULE NAME Left Right Criteria = 1 Criteria >= 1 ( Column Op Value ) Logical ( Column Op Value ) Logical Debit or = C AND Debit or = D AND Credit Credit Reference 4 = 086 AND Transaction = DW AND Type Reference 1 <> Reference 7 <> Left Match Group Right Match Group Tolerance Tolerance Left Item Additional Op Right Item Additional Tolerance Info (L) Info (R) Reference 1 = Reference 7 Effective DateYYYYMMDD = Effective Date YYYYMMDD 30 Days No Exception Combo Rule status Page 27 of 700 Output: RULE NAME Left Criteria Column Op Value Logical Right Criteria Column Op Value Logical Left Match Group Tolerance Right Match Group Tolerance Left Item Additional Info (L) Op Right Item Additional Info (R) Toleranace Exception Status Combo Rule EffDt <= 4 day .=1 Debit or Credit = C AND .=1 Debit or Credit = D AND effectiveDate Effective Date YYYYMMDD <= Effective Date YYYYMMDD 4 Days No Many DR Contract # .=1 Debit or Credit = C AND >=1 Debit or Credit = D AND Many DR Contract # Reference 4 = *086 AND Transaction Type = DW AND Reference 1 = Reference 7 Many DR Contract # Reference 1 <> Reference 7 <> Effective Date YYYYMMDD = Effective Date YYYYMMDD 30 Days No
... View more
Hi Team, Hope you are well. I need help. The flow have to generate a new column RT_changed based on the changing in the RT column by Month. Please find attached. Thanks, Srinivas
... View more