วีดีโอ

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?

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.

Use join or append to run Containers in sequence without manual intervention

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

Sir, i have multiple Output files, i want a consolidated sheet with a different sheet name.. can you help?

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.

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?

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.

Thank you & thank you!

Thank you sir for nice and clear video, I have a question pleas. I make a table that contains in culomn A doctors names and the headers in row1 is the month date. Inside the table all the cells has data validation with departments in hospital to make a monthly rota shift for the doctors. The list of the data valedation contains (main department, long shift, short shift, emergency, operation room, DAY OFF). I want to make a conditional FORMATING THAT IF I CHOOSE "long shift" from the data validation automatically gives this doctor "DAY OFF" for the next day and color the cell of "DAY OFF" in red. How can I do that.( For example if I choose in C5 "long shift" automatically mak D5 "DAY OFF" with red background in B5.) thank you.