Activate Specific Rows of Input files Based on User Selection.

[skotian1289]

Hello All,

I have built a tool which reconciles the 2 input files based on a Master Mapping for Column headers. That Master mapping has 1000s of Column Header names and multiple Recon combinations. I am not sure if its possible but I want the tool to search for column headers for recon based on User selection and not search the entire file everytime. See attached sample mapping file and below is what I am looking to achieve.

Step 1: The tool throws a Question to user with multiple options 

"Which Recon Combination you wish to select ?"

Recon 1

Recon 2

Recon 3

Step 2: Based on User Selection the tool will only activate those particulars rows and rest will be ignored. For Example if user selects Recon 2 then rows 9 - 13 will activated and tool will search names in only these rows, similarly if user selects Recon 1 as option then rows 3 - 7 will be activated rest will be ignored.

There are 1000 of such Recon combinations and the number column headers under each Recon combination will also vary based on different input files.

Thanks

[grazitti_sapna · Accepted solution]

Hi @skotian1289 , is this what you are looking for?

If yes, then kindly mark this post as solution else let me know.

Thanks.

[atcodedog05 · Accepted solution]

Hi @skotian1289 ,

Here is a workflow for the task.

App

Output

Workflow, I have tried to keep it simple optimized as possible.

Hope this helps : )

If this helps please mark the post as solution.

[atcodedog05]

Happy to help 🙂

Cheers and happy analyzing 😀