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:
Is there an easy (or complicated) way to add row numbers to a sorted data table?
I'm trying to get date selector interface for my end users so they will be able to define YTD date range on their side (1-OCT up to first day of month)
The issue I have is how to setup the expression part so it would be captured by interface buttons.
I have a CSV file which I have to load to a Oracle target. I have serval checks like number fields should be a number, Date should be a valid date, Length check for some of the character fields etc..
I need to capture all the errors in a table for a particular row.. Do I need to use filter tool multiple tool and then union?
Or is there any better way of achieving this?
I would look to utiise the Mutli-Field tool here, you can define a condition for each datatype that you are validating...for example using isNumber() to validate the numeric fields. This will then give you a boolean response for that field.
Once you have defined all of your conditions, you can transpose the results and then filter on any 0 (false) which will show you where there are errors.
I have attached an example
How can I remove the repeated information in a same cell?
You can see the information were separated by "," but some of them are repeated
Foe example, in the last line, the size description column has "ASST" and "XS" repeated twice.
How can I remove one of them and keep the unique information.
|STYLE||Color detail||COLOR_DESC||SIZE_DESC||Receiving Date||Receiver|
|GBD2018||BLUE,BLUE-ENAMEL BLUE,BLUE-ETHEAREAL BLUE,BLUE-MALIBU BLUE||BLUE||S6,L10-12,M7/8,XL1416,XS4-5,ASST,S6,L10-12,M7/8,XL1416,XS4-5,ASST,S6,L10-12,M7/8,XL1416,XS4-5,ASST,S6,L10-12,M7/8,XL1416,XS4-5,ASST||2018-01-02,2018-01-02,2018-01-02||Grace, Grace|
|GBD2014||NAVY-BLUE INDIGO,NAVY-BLUE INDIGO||NAVY||S,L,M,XL,XS,ASST||2017-12-15||Hope|
|GBD2014||BLACK-BLACK SOOT,BLACK-BLACK SOOT||BLACK||S,L,M,XL,XS,ASST||2017-12-15||Hope|
|GBD2014||GRAY-LIGHT GREY MIX,GRAY-GREY MIX BC15,GRAY-GREY MIX BC15,GRAY-LIGHT GREY MIX||GRAY||S,L,M,XL,XS,S/P,L/G,M/M,XL/TG,XS,ASST,ASST||2017-12-15||Hope,Hope|
How many fields are there in your file? 5, 10, 50? If it's just a few, you could just repeat and then join back. Or if it's many, a macro could be built out of the workflow. Here's all of the data you provided, cleaned up.