I have three separate Excel files that I need to combine into a single file, with each original file placed on a different sheet within the new file. How can I accomplish this using Alteryx?
... View more
I am trying to pull records from an API that is limited to 100 records per request. I am currently able to pull 200 records with the below workflow, but I know the object has at least 5 times that many records. Is there a setting I need to change in order to loop more than 1 time? **and is it possible to run the macro workflow in Designer Gallery? I don't have a run option when I upload this.
... View more
Hi I have a set of data that i calculate using an Alteryx workflow, the outputs are monthly costs for projects with certain identifying criteria, for instance below. I am sure this should be a simple answer, but how would I calculate the change in cost between the months where the first 4 columns are the identifier. I would need to run this for each previous month during the year as I receive each months new data. Any pointers would be very welcome Month Project Country Type Cost Jan 1 UK hours 100 Jan 1 DE hours 100 Jan 2 UK hours 100 Jan 3 UK hours 100 Feb 1 UK hours 200 Feb 1 DE hours 150 Feb 2 UK hours 300 Feb 4 FR Spend 100 Mar 1 UK hours 250 Mar 4 FR Spend 200
... View more
I am receiving Error Code 255 when I attempt to run my workflow using the following command: 'cd ' + [directory]+'\ && For %f in (*.xml) do type "%f" >> combined.txt & echo. >> combined.txt' When I remove the command following the mkdir command, the workflow executes correctly. Does anyone know what I need to change? I am ultimately trying to concatenate some xml files and output the combined file. Workflow is attached!
... View more
Hello, I am connecting to a shared inbox to gain insights into how the inbox is used. I am using the below code in the Python tool and am successfully connecting to the inbox, however it is only pulling in emails sent to the inbox from internal emails but most of the emails received in the inbox are from external emails. I am not familiar enough with Python to understand how to alter this code or if it is even possible. ------------------------------------------------------------- import win32com.client import pandas as pd # Outlook Connection outlook = win32com.client.Dispatch("Outlook.Application").GetNamespace("MAPI") #Folder Location folder = outlook.Folders['Inbox Name'].Folders['Inbox'] #Message Details messages = folder.Items # Initialize Lists (prep dataframe columns) senders = [] subject=[] email = [] body =[] categories =[] senton = [] receivedtime = [] # Iterate through messages for sender name and address. Searches for only mail items (class 43 and email type EX), exchange user is populated (inactive employee's exchange name #and email is removed). Appends sender, subject, and email. for message in messages: if message.Class==43: if message.SenderEmailType=='EX': if (message.Sender.GetExchangeUser())!= None: senders.append (str(message.Sender)) subject.append(str(message.subject)) body.append(str(message.body)) categories.append(str(message.categories)) senton.append(str(message.senton)) receivedtime.append(str(message.receivedtime)) email.append(str(message.Sender.GetExchangeUser().PrimarySmtpAddress))
... View more