I have a problem.
Input date has a string field having values something like this - 1733B
It means - Year 2017, 33rd week, and B is Monday ( week starts from Sunday).
I have to change this string to a date i.e 2017/08/14 (YYYY/MM/DD)
Can anyone pls suggest how to achieve this.
Hello Alteryx Community,
I am perplexed with the following problem:
1. I have three columns that is read using Connect-in-DB and they all have datatype 'V_String'
2. I used a Formula-in-DB tool to convert the field 'Value' into datatype 'Float' using this SQL expression (CONVERT(Real,"Value")) and this conversion is confirmed successful with the browse tool
3. I tie the output of this formula-in-DB to a summurize-in-db tool, but noticed that the datatype of the previously converted field 'Value' has returned to V_String. The issue is that I would like to average the 'Value' but is not able to do so unless it is a numerical type.
Help is really appreciated!
Solved it by trial and error.
1. Create a new field in the Formula-in-DB tool and only by doing this you can define the data type. In my case, I selected Double
It seems the SQL expression does not guarantee that the data type conversion would be implemented. The data type must also be explicitly defined in the formula-in-DB tool.
I'm new to Alteryx and would like to create dummy variables from a list of strings contained in one field.
How can I go from this table:
to this one:
Given my basic knowledge of Alteryx, I would really appreciate a solution without applications.
Thank you in advance for your assistance,
Here's my thought process. You want to parse the product type data with the underscore. Now you don't know how many types that you will find. That happens to be a good thing. You can parse the data to ROWS. Now each set of ID + Type gets it's own record. For each record that does exist, we will create a new field "Value" and set it to 1. We're vertical and have lots of 1's. Now go HORIZONTAL and create a header record for each type that exists. Using the cross tab tool, you'll create all product types as HEADERs and all known 1's as values. Where a product doesn't exist for a given ID, it is Null. Now you can use a multi-field formula to turn all nulls to 0's.
Sounds easy enough....
Guess what? It worked!
If you want to add "Product_" as a prefix to the field names, then in the formula you can modify the "NAME" value with:
I have had an unusual experience. I prepared a workflow and added it to a client's Gallery.
the workflow runs fine and there are no issues, however if one wishes to download these particular workflows, once imported the tools have shifted.
This is quite alarming as it has shifted to a very difficult place within the workflow, I almost have to zoom out to a maximum and scroll to the very corner of the page and locate 2 of my tool( input tool and select)
Has anyone experienced this issue before and if so how can I resolve it? think of it as an outlier that is furthest away from the dataset
I'll create a case for you and associate it with the project our development team has open on this issue to keep you updated.
Can you try changing your decimal separator to a '.' in windows number settings and let me know if you see the same?
Hello! I am looking to combine various elements of an address into one single column. For example the "base data" is available as so:
I want to end up creating a new column where each component of the address has been combined into a single phrase: "115 S Paul Dr"
An example by way of Excel: there is a formula to accomplish this (shown in formula bar) and the desired outcome shown in RED: "COMBINED_STREET_ADDRESS"
What is the Alteryx method to accomplish this item?
Create a new field in a Formula tool and use an expression similar to the following with all of the fields you want to concatenate:
tostring([street number]) + " "+ [prefix] + " " + [stree name] + " " + [street type]
Use the 'tostring()' function for the street number and any other field that comes through as a number. You could then use a Data Cleansing tool to get rid of the duplicate white space (for the instances where the original field was blank).
Hope this helps!
How do I turn this: 2017-01-15
I have multiple records of data with over 300 fields. I need to replace the contents of a subset of the fields with 0. Can someone suggest a solution?
Can anyone tell me whether you can lock or password protect a workflow or something similar that so other users do not overwrite anything in the existing workflow?
In case you still want workflow visibility, a solution that will stop this from happening accidentally is to use windows "read-only" functionality.
If you right click on the workflow wherever it is saved and select "Properties" you can check off the "Read-only" Attribute.
Then, if you try to make a change and save the workflow, you will get the following error in Alteryx:
The advantage of this method is that you can pretty easily uncheck this option so that you can write your own copy, and if the end user wants to see what your code is doing, or see the workflow as it runs, they can do so. The disadvantage is that basically anyone with access to this file/folder can probably uncheck the Read-only box, so someone intentionally or deliberately saving the workflow will still be able to do so.
You could also get even more advanced (depending on how this folder is secured) and add/remove baseline Windows security permissions for the file, so that anyone other than you/admins can ONLY read the file, and cannot save/edit it.
You will probably need to convert the workflow to a standard macro and then encrpyt it.
You can then drop this macro onto any canvas and run it.
I have a situation where in I need to arrange the data in order, for example a customer boards the bus from Station A to Station B called route 1, then he goes from station B to Station C and so on, however the data we have is not in sequence.
We need to find routes that are in succession. To identify the succession the customer recognized that the station he departs to in the previous route was the arriving station in his current route.
(1) Customer starts from his home and depart from bus station A (route 1)
(2) Arrives in station A and Departs to station B (route 2)
(3) Arrives in station B and Departs to Station C (route 3)
Attached is a example of how an iterative macro could be used to solve for find the next route segment each time. It could use a lot more work on things like how to handle if there isn't a "Home" to start from, or if a segment is missing. Hopefully this gets you started.
Is this a normal thing, or is there some setting that limits the number of rows for any output file?
As you can see, I have 678 records in my output and the tool is automatically splitting it into two files. Is there a setting that will force it into one file or stop it from doing this?
Also, here are my output settings: