Alteryx Designer Desktop Discussions

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

Filling missing values on the run

binnursev
7 - Meteor

Hello community, 

 

We have a file with three columns and we want to update the missing values manually from the information in the first column. Do you have an idea how a user manually enter the values during the run of the workflow and have an output with updated values? Please see the attached sample file

 

Thanks a lot!

Best 

 

Binnur 

2 REPLIES 2
MattBSlalom
11 - Bolide

To input data into a running workflow, you'd need to convert it into an Analytic App.  To input data in the middle of a running workflow (vs at the start), you'd need to have a Chained Analytic App.

 

With that said, in your case, it appears you need to enter various pieces of information per row based on the incoming spreadsheet.  Typically an Analytic App's interface is for standard / expected inputs.  It seems like you basically need a spreadsheet with those missing value rows to be able to complete the dataset.  Is there a reason you can't update the spreadsheet before executing the workflow to process it?

 

If it must be done during the run of the workflow, I'd go with the Chained App idea where the first app writes an output file with the rows that need data entry.  Then the 2nd app will allow the user to input the path to a completed data entry Excel file, and uses that with the original data file (for those rows that were already complete) for the rest of the processing.

Qiu
21 - Polaris
21 - Polaris

@binnursev 
Agree with @MattBSlalom , Alteryx is primarily intended for data process, rather than user interaction during the run.

Labels