- 39
- 20 940
Tutorials in 5 Minutes or Less
United States
เข้าร่วมเมื่อ 17 ก.พ. 2016
In this channel I will post tutorial videos with a maximum length of 5 minutes on business related concepts.
Youtube Reading TXT file based on delimiter
In this video I show you how you can read in a txt file and change the delimiter to different options.
มุมมอง: 40
วีดีโอ
Identify Groups with few records in Alteryx
มุมมอง 772 ปีที่แล้ว
In this video I show how you can use a summary tool to group by a specific column and count how many times you see a certain element. There are many use cases for this, including the one I use in the video that shows how you can identify groups that do not have few records. In this case we were looking to find employees that did not have a lot of projects on their workload and likewise projects...
Reformat strings missing leading zeros
มุมมอง 622 ปีที่แล้ว
In this video I show you how you can build an ID string using letters and numbers while keeping the number of digits the same using the PADLEFT formula.
SQL Case Statements in Alteryx
มุมมอง 5332 ปีที่แล้ว
In this video I will show you the equivalent of a CASE statement using Alteryx using two different methods. The first method is using the SWITCH formula and the second method is using a series of IF THEN ELSE statements. My preference is to use the second approach but both work just find to accomplish this task.
Add summary row to table of data in Alteryx
มุมมอง 2822 ปีที่แล้ว
In this video I show you how you can use a summary tool to find the "Total" of a field of data. After finding this total we are then able to use the merge tool to combine both of these streams of data back into one table.
Convert duration to HH:MM:SS in Alteryx
มุมมอง 1902 ปีที่แล้ว
In this video I will show you how to convert a duration string into proper HH:MM:SS format that can be used in Alteryx. In this example we are presented with durations that exceed 24 hours and will not automatically fit into the Time Type in Alteryx. In order to get our duration to be within 0-24 hours we use a MOD function that gives us the remainder after division.
Group by Value Without Segmentation using Alteryx
มุมมอง 2112 ปีที่แล้ว
In this video I show you how you can take values from a column and use the Cross Tab tool to format it into a table of data instead. However, with the way the data originates we cannot just go straight to using Cross Tab. First, we need to add some counting logic to determine were each group starts and ends based off of the common values in the rows. Then, once we have reverse engineered which ...
Proximity search for two words in a string in Alteryx
มุมมอง 1892 ปีที่แล้ว
In this video I will show you how to search for two different words to see if they are close or far from one another. The general method I used is to find where in the string each word is and count the number of words between the two words. In the event both words are not found I use a conditional statement to change the output.
Trim Out Double Quote from string using Alteryx
มุมมอง 4012 ปีที่แล้ว
In this video I will show you how I use string slicing to trim out double quotes from a string. Typically when using the formula tool and using a string in the formala you will surround it with double quotes, however, you are not limited to only using double quotes as you can use single quotes, too. This is useful in an instance where you need to identify double quotes, like in this video.
Jumping and Sorting in Excel
มุมมอง 82 ปีที่แล้ว
In this video I will show you how to quickly and efficiently move around your Excel data as well as how to use some keyboard commands to sort your data. I use these methods daily and rarely resort to slower methods. Let me know if there are any other topics that interest you as I am always looking for idea on new and relevant content.
My favorite method to parse names in Excel
มุมมอง 272 ปีที่แล้ว
In this video I go over how to parse a traditional name as well as how to parse a name with a middle name or multiple middle names. This is one of my favorite ways to parse non-standard names. Please leave any questions below or if you have a topic you want me to do next leave it in the comments below.
Calculating a 10 Day Running Average in Alteryx
มุมมอง 9082 ปีที่แล้ว
In this video I will show how you can use the multi row tool to achieve a 10 day running average. To do this we average the current row as well as the previous 9 rows, however, we need to remove the values in the first 9 rows as our first running average should begin in row 10.
Rounding Decimals in Alteryx
มุมมอง 2.9K2 ปีที่แล้ว
In this video I will show how you can round a decimal to an integer by using a select tool as well as rounding to different significant levels using a formula tool.
Reversing a name from "Last First" to "First Last" using the formula too in Alteryx
มุมมอง 1542 ปีที่แล้ว
In this video I will show how you can flip the name parts of a name by identifying where the space in the string is and then rebuilding the name to be the first name then a space then the last name.
Converting a string field into a numeric field that contains non numeric characters in Alteryx
มุมมอง 2.9K2 ปีที่แล้ว
In this video I will show how to convert numbers that contains non-numeric characters. For example, if -100 is presented as (100) Alteryx does not recognize this as a negative number and we need to remove the parenthesis and add a negative symbol.
Write multiple files dynamically based on column values in Alteryx
มุมมอง 2.1K2 ปีที่แล้ว
Write multiple files dynamically based on column values in Alteryx
Read multiple sheet names into Alteryx workflow from an XLSX file.
มุมมอง 1.3K2 ปีที่แล้ว
Read multiple sheet names into Alteryx workflow from an XLSX file.
How to create a "Total" row using Alteryx
มุมมอง 4.2K2 ปีที่แล้ว
How to create a "Total" row using Alteryx
Limits when you get (0/0) Part 2: Taking the conjugate
มุมมอง 358 ปีที่แล้ว
Limits when you get (0/0) Part 2: Taking the conjugate
Good one bro, but how to change positive number to negative, please help
Hi, How about to add multiple Total results in single column per workgroup in order to obtain a grand total of it?
I loved your video, but audio output is too weak. Even headphones aren’t helping much.
Thank you!! I could not find the annotation buttonm and was driving me crazy!
Glad I could help!
Is a CSV file type required to split into multiple files?
No, you can surely choose many file types and still accomplish this.
@@tutorialsin5minutesorless262 This does not work for Excel files. It defaults to output to different sheets instead of files.
awesome stuff!
Thanks!
While using multi field tool, how can we add a new column and add comment “no value” if the values in any columns is null ?
I suppose you would not need to use a multi field tool to do this. After all, if you only want to create one new field you can use the normal formula tool. Lets assume you have three fields, A, B and C, you can write a formula like this: IF [A] = Null() OR [B] = Null() OR [C] = Null() THEN "no value' ELSE 'a value exists' ENDIF This formula will produce "no value" whenever one of those fields is null. If you want it to show "no value" when ALL fields are null you would need to do this: IF [A] = Null() AND [B] = Null() AND [C] = Null() THEN "no value' ELSE 'a value exists' ENDIF
Many thanks to u
Thank you!
Thanks for sharing! I'm working on this project and is similar to yours, which is sheets 1, 2 in excel using directory but I kept getting error. If you have any thought
You will want to make sure when you use the dynamic input that you have the extra format of string that you need to read the full path.
What about multiple fields in one go
In this instance you can use the Multi Field Formula Tool. With this tool you will do the same formula but instead of selecting one field to alter you can select many.
thank you
You're welcome
this was helpful! could you also explain how to read multiple sheets from multiple excel files. thanks!
The reading of multiple sheet names does not change, all you would need to do it then read in multiple excel files. For example, lets say you are in your user profile of Kowgli and you have files on the desktop MyDataFile_1.csv, MyDataFile_2.csv and MyDataFile_3.csv. You can use the below file path with the asterisk. This lets Alteryx know to read all files from the desktop that start with "MyDataFile_". Therefore it will read all files from your desktop and all associated sheet names. Good luck and let me know if you have any additional questions. C:\Users\Kowgli\Desktop\MyDataFile_*.csv
How I see the data from different sheets? The final output of this workflow is the list of different sheet names, not the date from the different sheets
Thanks a lot! Short and sweet.
Glad it was helpful! If there are other topics you would like me to make videos on please let me know as I am always looking to make new and relevant content.