Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Need help building a Single Analytics App

EN6924
10 - Fireball

Hello Experts,

 

I have two samples file from which I need to extract- Change Request info, Type of Activity, Creation date, Filename.

 

I created a simple workflow to do that -

EN6924_0-1669200314007.png

 

Q1. Let's say I don't want to use the Input tool and directory tool both in same workflow. How can I do that in less number of steps?

Q2. Where & how should I add a file browse tool so that when end-users can directly point to the folder location and get the details?

 

Please help.

 

 

6 REPLIES 6
Sarreddy
9 - Comet

@EN6924  Hi 

Can you try it like this.

 

Sarreddy_0-1669207866074.png

 

Hi!

 

This is what I would do:

 

1. Using the File Input tool, you can select "File Name Only" for Option 5

2. Add the File Browse from the Interface category to your canvas and connect the magnifying glass to the lightning bolt on the Input tool. The Action tool will automatically populate. I tested it with the default configuration "Update Input Data Tool", and it worked well when I tested it in debug.

 

This is assuming you wanted the user to input a file, if you were wanting a different user experience, please let me know and I'll be happy to assist. :)

 

 

 

MichelleMitchellLutz_0-1669219042394.pngMichelleMitchellLutz_1-1669219058991.png

MichelleMitchellLutz_2-1669219151470.png

 

 

EN6924
10 - Fireball

Hi MichelleMitchellLutz,

 

I tested it and noticed that it works just as I had hoped; however, I did include an output tool so that users may download the outcome.

I previously added a Directory tool because I needed to include the request's (of the excel files) creation/submission time (date only will be sufficient).

 

Can that also be included in this app? Please let me know.

EN6924
10 - Fireball

Hi Sarreddy,

 

Thanks for the reply but it's not the output the way I wanted. 

MichelleMitchellLutz already helped me.

 

Hi!

 

1. To include the file and the creation time, you'll either need multiple tools or a batch macro. I'm happy to walk you through that if you'd like to see it. I used a Find and Replace (my fave, ha) to bring in the Creation Date based on the File Name. 

 

2. You can select View from the top bar, then Interface Designer to further customize your app. I added a Browse and Output tool and checked both to provide "On Success." 

 

 

MichelleMitchellLutz_0-1669640988289.png

 

MichelleMitchellLutz_1-1669641185235.png

 

 

Another option is a Batch Macro, see macro and instructions below. 

Labels