Can we use "Sendkeys" excel method in Alteryx or any similar function
You cannot send keys inherently from Alteryx, but you should be able to run a VB script or batch file that are written to perform the same functionality from Alteryx using the Run Command tool. Here are a few links to help get you started:
@patrick_mcauliffe - Thank you for your continued contributions to the Alteryx Community! Looks like you had a couple of extra characters in your hyperlink address.
Here is the corrected link: https://autohotkey.com/
I'm trying to convert an data file that's normally made using multiple Excel sheets to be created via Alteryx. One of the columns in the Excel sheet is a "Week of" field that indicates the Sunday of the week that the data is covered since we look at the data week by week. Normally, the aggregation of the data happens about 10 days after that starting Sunday (i.e. 2/11/2018 is a Sunday so when it says 'week of 2/11/2018' it'll cover 2/11-2/17, but the data for that week wouldn't be pulled until 2/21/2018). Because it happens later, the use of something like a DATETIMENOW or something formula isn't possible.
Is there a formula or a way to add the value of that Sunday? Right now, I'm just adding a formula and writing the date I want, but wasn't sure if there was a better way to do this
You'll need to add a formula tool with the following expression. Just swap out the [Date] for whatever your date field is.
DateTimeAdd([Date], Switch(DateTimeFormat([Date],'%a'),0, 'Mon',-1, 'Tue',-2, 'Wed',-3, 'Thu',-4, 'Fri',-5, 'Sat',-6), "days")
I'm looking for a solution to show the decimal time of 0.001837 as 00:02:39. I have searched around but I haven't found anything that accomplishes the task. The decimal time type is Double. Any help would be appreciated.
I'm wanting to create a workflow that will help me clean up some information coming in. I'm not sure how I would go about removing headers, and moving second column data in some of the rows to the headers.
A record ID changed. Year 1 depicts the sales using the old ID. Subsequent years show sales using the new ID.
I want to move the sales for Year 1 to the new ID. Sometimes the switch occurs after Year 2How can I do that?
Any ideas? I assume a Multi Row Formula tool, but I am a bit stuck.
I assume you have some sort of look up table or a way to link new and old IDs? If so, use that to assign the same ID to all records of the same customer. If you have a look up table, the Find Replace tool will be handy.
Once you have a common ID system assigned, a Summarize tool can be used to group by that common ID and find the sum of each year field. I have attached an example workflow.
I want to change the specific entry for just one field.
In the example below I just want to change the value for History from 0 to something.
Hello, this image is what I need, and each month will need to append columns. iin the attached YXMD, I got the results except for the STATUS column AND I will need to manually add calculations for each new month and change the sort order. Anyone have a better idea to offer?
Good catch. Replace 1 with [count] in the formula and you should be good.
IF [accept] = 'Y' THEN [count] ELSE 0 ENDIF
I also noticed that what you're calling YTD is really just a total of the dataset (2017 & 2018) so I had done the same. If you intend that to be YTD as of run data you will need to incorporate a calculation that partitions year to create YTD values.
How can I allow for a free type text box with more than one column and correctly show that in the interface designer?
I would like to be able to type in some variables and their corresponding values to be used in a formula at the end of a macro. Is there any way to do that? See picture below:
Ah, okay, I see... Then you might look at using the Multi-Line option in the text tool, and then just providing additional instruction on how to enter your selections. See attached... basically, indicate how you want your variables separated (i.e. identify the delimiter to use), and then instruct the user to enter a single variable-value combination per line. You can then feed your results into a text field and use two Text to Columns tools to parse out the variables & values (split to rows by newline to separate different entries... and then split to columns using your specified delimiter). You could then use Cross-Tab to pivot the data to show your variables as headers and the values selected below each header.
Does that help? I'm not aware of a tool currently that will allow you to set up multiple individual text boxes (though there are a few Alteryx wizards out there who might have other ideas)... but this method at least would allow for any number of variables.
Happy Friday everybody,
It's been a busy week now it's almost time for a well deserved rest.
You did good this week. Well done you.
@SophiaF is the beer fridge open by any chance?
How thoughtful, this brightens up my day, thank you!!!
From a survey of the Support team at the Alteryx London office:
I have several files with 2 .mdb files each. I would like to:
Unzip and rename the .mdb with the original name of the file included in the .mdb.
IE. A file name PL0400 has a zip file called work. In the work file there are two .mdb files, abc.mdb and efg.mdb. I would like to name the files PL0400_abc.mdb and PL0400_efg.mdb.
I have tried to unzip one file but I get an error: "error reading abc.mdb":Too many fields in record #23
I am using a file input with the input as PL0400 connected to a Run Command using winzip
This type of error most often occurs when reading in CSV files. Please see the following article in our Knowledge Base: Error reading "FILEPATH\MYFILE.txt" Too many fields in record #.
That being said, our .zip file support only supports certain file types, of which .mdb is not one: https://help.alteryx.com/11.7/index.htm#DataSources/ZipFiles.htm?Highlight=zip. I'm thinking you're choosing to read other files as CSV. I can work around the error message by setting the delimiter to no delimiter (\0) and treating read errors as warnings. However, the data read in is not standard text and cannot be used.
Your problem is likely best solved by a batch script. SS64 is a great command line reference!
Customer Support Engineer