Need help building a Single Analytics App

Question

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 -

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.

Test1_Using_File1&File2.yxmd

File2.xlsx

File1.xlsx

MichelleMitchellLutz · Accepted Answer

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 · Accepted Answer

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 · Accepted Answer

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