![technobi](/img/default-banner.jpg)
- Видео 24
- Просмотров 159 875
technobi
Индия
Добавлен 20 июн 2020
The purpose of this channel to share my knowledge and experience in particular skills like Alteryx, Tableau, MS Excel, macros, VBA etc. that I acquired over time and help others. I share mostly business scenarios that helped me solving problems in my work area so that one can benefit from it if encountered a similar situation.
Please drop a mail to info@technobi.org for training related information.
Please drop a mail to info@technobi.org for training related information.
Designing a Simple Alteryx Workflow
Designing a Simple Alteryx Workflow From Beginner to Advance.
Please visit technobi.org/alteryx-designer-core-exam-sample-questions/ for Alteryx Designer Core Exam Sample questions.
Reach to me at technobi.org@gmail.com.
Please visit technobi.org/alteryx-designer-core-exam-sample-questions/ for Alteryx Designer Core Exam Sample questions.
Reach to me at technobi.org@gmail.com.
Просмотров: 122
Видео
Alteryx Designer Core Exam Sample Questions and Solution
Просмотров 1242 месяца назад
In this video we will solve a couple of possible questions that might be asked in Alteryx Designer Core Exam. For more sample questions visit technobi.org/alteryx-designer-core-exam-sample-questions Reach out to me at technobi.org@gmail.com in case you need further guidance. Thank you.
Alteryx Core Exam Sample Question - findstring expression
Просмотров 1786 месяцев назад
In this video, a possible sample question is solved that might appear in Alteryx Designer Core exam. For more sample questions visit technobi.org/alteryx-designer-core-exam-sample-questions Reach out to me at technobi.org@gmail.com in case you need further guidance. Thank you.
Alteryx Designer Core Certification Exam Practice Test Course | Alteryx Exam Sample Questions
Просмотров 2,9 тыс.3 года назад
I have published a practice test course alteryx designer core certification exam. This course covers all the tools that are tested in the exam. www.udemy.com/course/comprehensive-practice-test-for-alteryx-designer-core-exam/?couponCode=A606606FDECA4AACDEAA For more sample questions visit technobi.org/alteryx-designer-core-exam-sample-questions Reach out to me at technobi.org@gmail.com in case y...
Alteryx Core Exam Sample Question
Просмотров 10 тыс.3 года назад
Here is my experience of writing the Alteryx Designer Core Certification Exam. I will be sharing few more tricks and samples in coming videos. Please subscribe to stay informed. Please write to me on info@technobi.org if you want any help in preparing for the exam. For more sample questions visit technobi.org/alteryx-designer-core-exam-sample-questions Reach out to me at technobi.org@gmail.com ...
Alteryx Analytic App - How to run multiple workflows in succession, one after the other
Просмотров 15 тыс.3 года назад
In this video we will see how can we run multiple alteryx workflows in sequence. The workflows should run one after the other. The Formula used in Action tool Formula field - IF [#1] THEN "FALSE" ELSE "TRUE" ENDIF For more sample questions visit technobi.org/alteryx-designer-core-exam-sample-questions Reach out to me at technobi.org@gmail.com in case you need further guidance. Thank you. Thank ...
Dynamic Input - How to choose input file automatically and import into Alteryx workflow
Просмотров 9 тыс.3 года назад
In this video, we will see how to choose the latest file in a particular folder automatically and import data to run the Alteryx workflow. For more sample questions visit technobi.org/alteryx-designer-core-exam-sample-questions Reach out to me at technobi.org@gmail.com in case you need further guidance. Thank you.
Conditional Formatting in Tableau. How to conditionally change font color and tooltip in Tableau
Просмотров 5 тыс.3 года назад
This video explains how to conditionally change font color and tooltip for certain rows and columns in tableau text table.
Find Replace Tool - Look Up Function in Alteryx
Просмотров 4,8 тыс.3 года назад
Find Replace Tool in Alteryx is the Look Up Function Similar to Look Up Functions in Spreadsheet. Using this tool we can search with a string value and replace an existing field or add value from another dataset to the existing data set. For more sample questions visit technobi.org/alteryx-designer-core-exam-sample-questions Reach out to me at technobi.org@gmail.com in case you need further gui...
How to Combine Multiple Spreadsheets and Get Output in Multiple Tabs in Output File in Alteryx
Просмотров 6 тыс.3 года назад
In Alteryx, combine multiple spreadsheets and get output in one single output file but in different tabs for each input file. Refresh the tabs each time by running the workflow whenever required. For more sample questions visit technobi.org/alteryx-designer-core-exam-sample-questions Reach out to me at technobi.org@gmail.com in case you need further guidance. Thank you.
How to select date range automatically in Alteryx and Tableau
Просмотров 1,4 тыс.3 года назад
In this video we will see how to select a date range automatically in Alteryx output file or Tableau report so that we will not have to change the dates manually every time before running the workflow in Alteryx or while publishing the dashboard in Tableau. For more sample questions visit technobi.org/alteryx-designer-core-exam-sample-questions Reach out to me at technobi.org@gmail.com in case ...
How to Use Output File as Input File in Alteryx
Просмотров 1,7 тыс.3 года назад
We can also convert our output file in Alteryx as Input file by converting it to Input file. For more sample questions visit technobi.org/alteryx-designer-core-exam-sample-questions Reach out to me at technobi.org@gmail.com in case you need further guidance. Thank you.
How to Use Formula and Filter Tool in Alteryx? How to Format Date in Alteryx Using Date Specifiers?
Просмотров 1,9 тыс.3 года назад
In This Video, We Will Learn About Few of the Most Useful Tools In Alteryx. We Will Learn How To Use Formula Tool, How To Use Filter Tool, Brief about Summarize Tool, Date Specifiers for Formatting Dates (4:00 min), How to Arrange Fields in Formula Tool, How to Check Available Functions in Formula Tool. For more sample questions visit technobi.org/alteryx-designer-core-exam-sample-questions Rea...
How to Insert URL/Hyperlink to Tableau Dashboard
Просмотров 19 тыс.3 года назад
In this video we will add a URL to tableau dashboard and link to an image. When we click the image in the dashboard it should take us to the website or webpage that we linked to the image.
How to Save Output in Separate Tabs based on Values in a Field
Просмотров 4043 года назад
In this video I am demonstrating how to get the output in separate tabs in one excel file based on values in a field. The output will be separated into different tabs based the values or groups that are available in one particular field. Another video where I have demonstrated how to get the values in different tabs: ruclips.net/video/nenXfsDIZ0w/видео.html&ab_channel=Technobi
How to Choose File Path Automatically in Alteryx?
Просмотров 7 тыс.3 года назад
How to Choose File Path Automatically in Alteryx?
How to use Transform Tool, Transpose Tool, Cross Tab, Summarize, Count Records Tools in Alteryx?
Просмотров 2,5 тыс.3 года назад
How to use Transform Tool, Transpose Tool, Cross Tab, Summarize, Count Records Tools in Alteryx?
How to Rename and Rearrange Fields using Select Tool in Alteryx
Просмотров 4 тыс.3 года назад
How to Rename and Rearrange Fields using Select Tool in Alteryx
How to Calculate Network Days or Business Days in Alteryx? Excel Network Days equivalent in Alteryx.
Просмотров 1,4 тыс.3 года назад
How to Calculate Network Days or Business Days in Alteryx? Excel Network Days equivalent in Alteryx.
How to Create a Shared Workbook with Restricted Sheet Access
Просмотров 44 тыс.3 года назад
How to Create a Shared Workbook with Restricted Sheet Access
Restricted shared workbook - Part 1 (VBA Code to Print Username to Excel workbook)
Просмотров 1,4 тыс.4 года назад
Restricted shared workbook - Part 1 (VBA Code to Print Username to Excel workbook)
How to save output in multiple tabs in one single excel output file in Alteryx
Просмотров 11 тыс.4 года назад
How to save output in multiple tabs in one single excel output file in Alteryx
How to get Date of any weekday in Alteryx?
Просмотров 2,4 тыс.4 года назад
How to get Date of any weekday in Alteryx?
How to Add or Insert Date to Output File Name in Alteryx Workflow
Просмотров 8 тыс.4 года назад
How to Add or Insert Date to Output File Name in Alteryx Workflow
Why the bak file was also writen?
Thank You Sir
How to get a sigle output by using multiple excel data into a single input command, that means, instead of putting/insurting multiple input files into a input command can we use a entire folde which have multiple files with different header names but same inside excel header s and get a single output of that total excel files data?
You can use dynamic input tool along with the directory. Then it will fetch all the files in the directory
this is very old, they don't have an option to hide sheet in 2024 or at least I'm trying to find it
Very Useful. I have a issue where the column has a list of hyperlink in string format. How to convert into a hyperlink
The solution did not work for me. error pop up - The process (Ex: People output) cannot access the file (Ex: Consolidated) because it is being used by another process (Ex: Orders). Please advice.
Output configuration select overwrite and use block until tool for writing output one by one. Hope this helps.
Use join or append to run Containers in sequence without manual intervention
how to do pls I have one tool one 2 tool conatiner how to do
Hi, I Extract excel files every Friday and save it on the Shared Drive. As part of my Alteryx Solution, I have 2 Inputs tools, 1 which reads/imports the Last Friday's Excel File and the other Input tool which reads /Imports the Current Week Friday's data. So , How do i configure the above workflow which you mentioned so that , My Alteryx Workflow extracts the excel files accordingly as i have mentioned
Good job
Is there an easier way to do this now?
ek no,mast hey
Can you please share workbook as the link seems invalid
Please make more videos on Alteryx.. subscribed
give me answers in design core exam
How did you assign user1 to use1 tab? How can you do that to multiple users for different tabs
Hello, how do i get this workbook because the link you provided is not working
Thanks for the amazing video and useful information. But I ran into a problem when my excel file had more than 1 worksheet. In this video you have not explained how to specify worksheet name from the source file to Dynamic input node , hence I get error "No table chosen; Please select a table from datasource". Please explain how I can specify which worksheet the workflow has to consider while executing, if there are more than 1 worksheets. Thanks in advance!
Nice man! Thanks for the solution!
How can I add date at the end of the file?
Very clear. Thank you.
Is restricted access maintained if the users opens the document on a mobile device?
Gracias! 👍
U should have shown from the start
Hie can you email me the formula please
can we please get the code for this process. Still its not available on the link
@2:25 .. what did you write .. the resolution is too low and it gets pixelated ..!!
Thank you so much for this very well explained and slow step by step need more videos like this.
you are a true legend, my friend
how can we get coding?
can you get 2 workflows to run in sequence just by clicking the RUN button? We are moving to automation so I want to be able to do this without having to click on anything other than the systemic click of the "RUN" button Great video though!
Hi Sir, What if, The USA data is unavailale for the data, will the sheet export or atleast an headers will export?
Unable to view coding given link
Somehow the codes are cleaned from the workbook while the hosting site is scanning for threats. Will update the code in description soon. Please be little more patient. Thank you for your support!
Oh Dear! This is exactly what I need but the link directs me to 404 error. 😢
Sir, i have multiple Output files, i want a consolidated sheet with a different sheet name.. can you help?
Will comeback on this. Thank you for your support!
Amazing video mate. Just what we were looking for. You saved us days of trying to figure this out ourselves!!!
Thanks for sharing this info, it is very simple which is crisp and clear :)
Bhai.. what did you write in formula
I wanted to use a text and not a logo for this. So, a quick workaround is to create the text in MS Word / Google Docs and using snipping tool to create an image of that text. Thus, you can now use this image as a hyperlink.
does it mean, the folder has to be in Cdrive for this option to work? what if the folder name is changed from Alteryx "New" to something else. will it still work?
How to update different comments in different fields in alteryx
how can i contact you sir i have doubts urgent !
Hm I get an error that it's unable to open my consolidate file once the first part of the flow runs.
same same how do you solve it?
@@wumengxuan760 I was able to resolve the issue, but it's been a few months and it's all a bit fuzzy. I want to say I got the solution from their community forums.
What if one of the Workbooks has more than one sheet? Will this still work?
Hi, Can we get past date also by using this method
So if anyone works on the workbook, thier additions, edits, etc will be synced and shared with others or not? If not, how do we do that? Thank you
Great
are the questions hands on or only kinda multiple choice?
Both. There's a fair few hands on, which makes you download a spreadsheet and asks you a question which you need to use Alteryx to answer. Most of them are hands off though.
how can I get the formula
Can you let us know how to automate it entirely without manual intervention of choosing the radio button?
I am struggling at one area. In one column i have items written as years as 2010, 2011 etc. I want these to be detected as date. How can I do that?
Thank you so so much. Your video was very helpful. I understood the formula tool.