@Vijay: We are glad that you like our videos. Its really motivating for us. We will try our best to create more videos on alteryx with right use cases.
Hi Vaibhav sir. I have been working with alteryx for the past three months. I have a task to combine all the multiple excel sheets into one by using alteryx. Can you able to help me ??
Utilize the input tool to get the sheetnames of the file. Then using a formula tool create a new column - "SheetPath" having value as - "Original Path of the file" + "Sheetname". Pass this column "SheetPath" as a control parameter to the Batch macro replacing the path in dynamic input tool. This will combine your data from all the sheets for that particular file.
I have one report to be made, there are multiple steps and filters, but for one supplier( luxsoft Poland) if we get a confirmation team, then we need to remove those records from report and keep them in separate sheet else we need to have them in output report
You can use the batch macro where filter condition can be changed dynamically based on the input to batch macro. In that way you can achieve such a scenario.
I have a workflow in which I am using drop down interface tool which has five values . I have created five containers which runs based on user selection in drop down...but problem is i am using a different drop in few of the containers. when I run the wf as analytics apps all the user input is displaying..but I want to show the user input of container when those container is selected..how to do this?
The videos from your side didn't give me the feel of fundamental understanding of tools used in this workflow. Can you make small small videos on use cases of all INTERFACE TOOLS
@Vijayaragavan: Thanks for the feedback. We have taken it seriously. In upcoming videos, atleast for next 2-3 months you can find videos on individual tools of Alteryx
Hi vaibhav sir your videos are good. iam excepting two videos every week. this may help to learn more about alteryx
@Vijay: We are glad that you like our videos. Its really motivating for us. We will try our best to create more videos on alteryx with right use cases.
Thanks Vaibhav. You saved my day🎉
Glad to hear that
Hi Vaibhav sir. I have been working with alteryx for the past three months. I have a task to combine all the multiple excel sheets into one by using alteryx. Can you able to help me ??
Utilize the input tool to get the sheetnames of the file. Then using a formula tool create a new column - "SheetPath" having value as - "Original Path of the file" + "Sheetname". Pass this column "SheetPath" as a control parameter to the Batch macro replacing the path in dynamic input tool. This will combine your data from all the sheets for that particular file.
Nice👍
We are glad that you liked our video.
I have one report to be made, there are multiple steps and filters, but for one supplier( luxsoft Poland) if we get a confirmation team, then we need to remove those records from report and keep them in separate sheet else we need to have them in output report
You can use the batch macro where filter condition can be changed dynamically based on the input to batch macro. In that way you can achieve such a scenario.
I have a workflow in which I am using drop down interface tool which has five values . I have created five containers which runs based on user selection in drop down...but problem is i am using a different drop in few of the containers. when I run the wf as analytics apps all the user input is displaying..but I want to show the user input of container when those container is selected..how to do this?
@Amit: Can you please share your workflow packaged with data on email: imvaibhav11@gmail.com. We will send it back to you with some adaptions.
The videos from your side didn't give me the feel of fundamental understanding of tools used in this workflow.
Can you make small small videos on use cases of all INTERFACE TOOLS
@Vijayaragavan: Thanks for the feedback. We have taken it seriously. In upcoming videos, atleast for next 2-3 months you can find videos on individual tools of Alteryx