- 24
- 173 460
technobi
India
เข้าร่วมเมื่อ 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.
มุมมอง: 217
วีดีโอ
Alteryx Designer Core Exam Sample Questions and Solution
มุมมอง 3055 หลายเดือนก่อน
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
มุมมอง 2438 หลายเดือนก่อน
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
มุมมอง 3K3 ปีที่แล้ว
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
มุมมอง 10K3 ปีที่แล้ว
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
มุมมอง 16K3 ปีที่แล้ว
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
มุมมอง 10K3 ปีที่แล้ว
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
มุมมอง 6K3 ปีที่แล้ว
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
มุมมอง 5K4 ปีที่แล้ว
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
มุมมอง 6K4 ปีที่แล้ว
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.4K4 ปีที่แล้ว
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
มุมมอง 2K4 ปีที่แล้ว
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?
มุมมอง 2K4 ปีที่แล้ว
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
มุมมอง 20K4 ปีที่แล้ว
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
มุมมอง 4474 ปีที่แล้ว
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: th-cam.com/video/nenXfsDIZ0w/w-d-xo.html&ab_channel=Technobi
How to Choose File Path Automatically in Alteryx?
มุมมอง 7K4 ปีที่แล้ว
How to Choose File Path Automatically in Alteryx?
How to use Transform Tool, Transpose Tool, Cross Tab, Summarize, Count Records Tools in Alteryx?
มุมมอง 2.7K4 ปีที่แล้ว
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.3K4 ปีที่แล้ว
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.6K4 ปีที่แล้ว
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
มุมมอง 51K4 ปีที่แล้ว
How to Create a Shared Workbook with Restricted Sheet Access
Restricted shared workbook - Part 1 (VBA Code to Print Username to Excel workbook)
มุมมอง 1.7K4 ปีที่แล้ว
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
มุมมอง 12K4 ปีที่แล้ว
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.5K4 ปีที่แล้ว
How to get Date of any weekday in Alteryx?
How to Add or Insert Date to Output File Name in Alteryx Workflow
มุมมอง 8K4 ปีที่แล้ว
How to Add or Insert Date to Output File Name in Alteryx Workflow
Is this supposed to be a tutorial or what?
the link directs me to 404 error
This is very useful, thank you for sharing it with us.
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
@@technobi0911 If it have different header names, Dynamic Input tool won't work. Need to use Macros Instead
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