New structure, new look! Read all about enhancements to the community in v5.0.READ MORE
I have data on several different vendors, which includes all of the vendor's locations in a single record. What I want to be able to do is create an individual record for each vendor location combination
|vendor 1||3||xyz||3||xyz||Chicago||Tom Jones||Houston||Jon Doe|
|vendor 2||2||xyz||2||xyz||New York||Jim Smith||LA||Betty White||SF||John Smith|
|vendor 1||3||xyz||3||xyz||Houston||Jon Doe|
|vendor 2||2||xyz||2||xyz||New york||Jim Smith|
|vendor 2||2||xyz||2||xyz||LA||Betty White|
|vendor 2||2||xyz||2||xyz||SF||John Smith|
Any help is appreciated! Thanks!
I have a list of tables that need to copied from one database to another. The list resides in the table in a DB. I am trying to write a Standard Macro to perform this. This is what I have so far.
The macro reads the in list of tables and then reads that using the Dynamic Input. But I am unsure how to write the tables to the second DB. Please advise.
The macro in this post shows something very similar (batch.yxzp), but instead of having a macro output within your batch macro you will have your output data tool, and use the value passed into the control parameter to overwrite the value on the input tool (so it loops through all of the input tables) and also overwrite the table name in the output tool, so you write a new table per batch.
Check this out. try and apply it and let us know where you get stuck.
I have an input sheet that will update weekly based on the date. This week is 'Available 18 Jun 2018' and next week will be 'Available 25 Jun 2018' and so on.
So to avoid a conflict with the header renaming every week when I repull the sheet and run - I used a select tool to rename the field 'Week 1'. I have a filter set up that has the expression '[Week 1] >= 20 AND [Local grade/Job level] != "Director"' (it did say "[Available 18 Jun 2018] >= 20 AND [Local grade/Job level] != "Director"' originally).
But when I output the data I don't want it to say Week 1 - I want it to be the actual week description (like Available 18 Jun 2018). I can't see a way to reference back to the original, so maybe I need to use a more generic name in the filter? What do you think?
TYIA for the help.
I am getting these errors, despite having my date field configured properly, setting start date to coincide with date fields and giving the right # of periods. I have also imputed any null values with zero, and there is no row without an identifier. Not sure where i am going wrong.
AB Trend (7) AB Trend: The range of the dates in the data is not consistent with the test start date and/or the number of periods to base the trend measure on and/or the reporting period of the data.
AB Trend (7) Tool #225: Error in svd(x, nu = 0) : a dimension is zero
AB Trend (7) Tool #225: Execution halted
AB Trend (7) Tool #225: The R.exe exit code (1) indicated an error.
AB Trend (7) Tool #227: The field "Identifier" is not contained in the record.
A couple of things I noticed.
Missing data for 2017-08-01. This will cause problems. I got around it by duplicating data from 2017-07-01 but I don't know what is appropriate in your case.
Many accounts had 0 values for all relevant time periods. this causes divide by zero errors in the macro. I resolved by simply removing the accounts with 0 values. This is obviously not appropriate in the real world and you'll need to give some thought to this issue.
Make sure the start date is set such that the supporting data includes a full year plus 2 of the periods. I tested against 2017-12-01
Set the Show All Macro Messages option in configuration - runtime to see all the errors.
I am new to Alteryx and have mostly used SAS Enterprise Guide.
I am wondering if there is a way to sort and then select the first record of each sort by group.
First use a SORT tool and then use a SAMPLE tool (configured as FIRST N Records) with the "Group by" field(s) checked.
Yes! Check out the sample tool. Here you can select the 'First N' records, in your case 1.
It also allows you to select fields to 'group by', which means the expression ends up as...
Select me the first n records for each member in these groups.
Have a play and let us know if this brings you to the solution you need!
I would appreciate your help for the below.
I am trying to do the calculation of (A+E-I) in column Group_2 based on Group_1 and Date columns. The output should give me the result of (A+E-I) for each date in Date column based on Group_1 e.g. for the date 01/2018 for 1 (in Group_2).
I Would appreciate if you can show me a way. Thanks a lot from now!
Okay, it seems like the value in 'Group_2' is derived from the date field. So I would remove this from all the 'group bys' I mentioned, either in the cross-tab or summerize tool, depending on which method you use.
Solution attached. Let me know if this meets the requirements.
I need a help to sum a range of rows from one file and put it in a different file using Alteryx. Below given is an example.
1. Previous Month Data
2. Current Month Data
Each file have two columns
I need to create two new columns in addition to existing columns (1.Cumulative Forecast & 2.Cumulative Actual) in the Current Month Data file.
Cumulative Forecast field should fetch the data from "Previous Month Data" file and sum up of each month like it's given in the example.
Cumulative Actual field should fetch the data from "Current Month Data" itself and sum up of each month like it's given in the example.
Any help how this can be done in Alteryx would be appreciated!
I would start by joining the 2 datasets together (using month as the key) and then you can use the running sum tool produce your cumulative values :)
I think we can achieve this in a relaitvely straight forward manor involving a join between the two tables on 'month' and then using the running total fields on each of the values within the files.
See the attached example.
New to Alteryx, wanted to reach out to see if there was a way to convert a date into a business day during the month.
Okay I think this macro does what you are looking for, but I would do some testing before you use it in anything.
There are two inputs
D - Data Stream with date field
H - Optional Holidays table
There are two outputs
M - Matches/Data stream output.
N - non matches - will only return data if the "include saturday and sunday in nearest business day in the same month" checkbox is NOT selected.
Note: if the month splits between saturday and sunday (i.e. sat is 7/31 and sun is 8/1) then Saturday will be included in the nearest business day of the previous month and Sunday will be include in day 1 of the next month.
Let me know if you have questions.
I have a data set where the first column contains both identifier and dates like this example:
Prior to the rows that have dates and data points relating to those time periods, it always says "Data Point" in the first column. I'd like to split the data into two columns everytime "Data Point" appears. Any ideas?
Thanks in advance!
Hi @cmohyi it sounds like you want something like attached but your sample is too small to build a complete solution without knowing the complete data structure.
Do you want to take a look through this solution and add any problems you have with the solution.
What is the best practice to summarize data with Alteryx? For example, I would like to summarize the unique id, measure names by adding the numerators and denominators.