I am completely new to alteryx and trying hard to get something similar using in Excel which is the use of Countif along with named ranges, below is the expression used in the attached sample "Sheet1" from column F to J row number 7 to 15:
COUNTIFS(Band1,">=" &A7,Band1,"<=" &B7)
Sheet2 - contains my named ranges which I have used in above equation to identify the number of years in each band based on column A (BeginYear) and B (EndYear).
Do you think above is doable in Alteryx? I am really struggling please if someone can kindly shed some light, appreciated in advance.
I am currently working on re-doing a very manual excel process with Alteryx. I have been struggling to find an effective way of checking my results.
The end data set comes from combining several input data sets and ends up being ~80,000 records with 100+ columns, I need to be able to check my results (using old data) with a version that is correct from the current process. However I need to check each record in each column and see clearly where things have went wrong.
I have tried joins on joins etc but wondered if anyone had any innovative ideas? I also need to check EVERY record so sampling doesn't work.
Any ideas greatly appreciated
I am trying to insert a column which for each row of data will examine the values in 4 other columns and will return the name of the column containing the highest value (Primary) and then repeat this inserting columns for the name of the column containing the second highest value (Secondary) and third highest (Tertiary). I was able to do something similar in Excel using the =Large() function however this was limited to returning the value itself rather than the name of the column.
All help is greatly appreciated.
Lets say I have the dataset
Transpose your dataset, using the ID as a key field (use the record ID tool before the transpose), and the columns you want to compare against will be your data fields. This will give you something link...
You can then use a sort tool to place the values in the order you want to create a 'rank' with. Use the sort tool, sorting by your RecordID field and then the value, either descending or descending depending on what you are about.
You can then use the multi-row formula tool to create a nested rank which restarts for each group.
Use the option 'create new column' and lets call this rank.
Your formula should be
Making sure you use your RecordID field as a 'Group By' in the list box.
You can then use the cross-tab tool to bring your data into a format looking like:
I've attached the example workflow of how this can be achieved.
Do you mean something like this?
I am having a strange problem that alteryx is only letting me import 100,000 rows in the Input Tool when connecting to a .csv file locally on my machine.
I have searched but have not found any reference to any limitations of size restrictions that should be causing this.
Does anyone have any ideas?
I'd like to parse out some folder names and use them to organize my data. I'm currently using a directory tool that outputs the filename and uses batch macros to combine multiple files together. The macro works, now I'm just trying to grab the folder that each file came from as an additional data field.
Currently the File name looks like this: \\SharedDrive\Organization\Folder Name 1\Folder Name 2\Survey.xlsx|||'Survey 2015$'
I know this can be done with multiple text to column tools using "\" as a delimiter, however, this task I do relatively frequently and would like to know how I can use RegEx to parse out that folder name. I have previously used [-](.*) regex to treat "-" as my delimiter, but I am unsure on how to use special characters like "\".
Any help is greatly appreciated!
Am getting started into Alteryx and am having trouble doing the following manipulation.
I have many rows which have a common ID fields. I would like to put all the different values of the columns of the rows within the same row as different column values.
I currently have the following format
I would like to turn it into
The order of the bc/ef/ij depends on the sequence of the dates, with the first dates to the left and latest dates to the right.
Would love to get your help!
I have a dataset which has strings in the format below
ABCDE F GHIDJ
AB C DEFGHIJ
ABCD E FGH I
I would like to find a way to only remove the character that is by itself.
ABCDE F GHIDJ --> ABCDE GHIDJ
AB C DEFGHIJ --> AB DEFGHIJ
ABCD E FGH I--> ABCD FGH
I tried used the RegEx tool however am not really sure how to use it.
Thanks for the help in advance!
Again, probably another simple question, but I am trying to figure out how to write the expression for a cude root of a variable in the formula tool. Any ideas?
Does one exist? Can it be shared with customers? Something like what Tableau provide below:
You can access Connect internal database via this step-by-step guide: https://help.alteryx.com/connect/current/index.htm#Administration/UsageStats.htm%3FTocPath%3DAdminis...
In internal Connect database you can find "core tables" (internal storage for Connect) and "metadata stage table" (stage tables used by metadata loaders).
See description of the core tables here:
|table name||table type||description|
|ACTION||core table||Action, tracking of actions performed|
|ACTIVE_WORKFLOW||core table||Lifecycles - defined lifecycles, and entries where lifecycle is activated (workflow)|
|ATTACHMENT||core table||Attachement storage for all files attached|
|ATTRIBUTE||core table||Entry attibute in key-value format. Extended entry information like Description, display type|
|COMMENT_THREAD||core table||Comment Threads|
|COMMENT_THREAD_RESOLUTION||core table||Resolution log of commens|
|CONFIG||core table||Place where archetype XML configs are stored (applications, loading jobs, fragmets, scripts)|
|CONNECTION||core table||Connetion as configured on "..." menu (designed for connection USE button)|
|CONNECTION_PARAMETER||core table||Connetion details as configured on "..." menu (designed for connection USE button)|
|DATABASECHANGELOG||core table||List of database structure modifitations. Used during updrade|
|DATABASECHANGELOGLOCK||core table||Lock table when DB upgrade is in progress|
|ENTRY||core table||Entry definition. Each single object in system starts here.|
|ENTRY_HIERARCHY_CHANGE||core table||Tranking changes on entry hierarchy|
|ENTRY_PERMISSION||core table||Permissions table|
|ENTRY_STATE||core table||Entry lifecycle state (public, draft) as defined in lifecycles|
|EVENT_AUDIT||core table||Security log, users sign in activity|
|EVENT_MONITOR||core table||Security log , user actions|
|RELATIONSHIP||core table||Relationship table|
|SENTIMENT_LIKE||core table||ThumbUp and Thumb down|
|SCHEDULER_STATISTIC||core table||Internal scheduler statistics|
|SUPERADMIN||core table||Super admin account andormation if non default|
|TM_STATE||core table||Time machine state. Used when prowsing time machine history|
|TODO||core table||Todo List|
|TODO_ACTION||core table||Todo Action|
|WATCHER||core table||Wathers definition. Who is watching what entry|
|WORKFLOW_TRANSITION||core table||Log of lifecycle changes.|
The other option to use REST API to query and access all information stored in the connect (this REST API will be released soon).
Alteryx Connect Team
I am new to Analytic Apps. I am trying to use a List Box to pass values to a Filter Tool using a similar idea on another post.
I cannot figure out why it is not working. Any ideas or solutions as to what I am doing incorrectly.
Thanks in advance.