How to get the specific range of fields based on the data or country data selected.

[arjundelara]

Good Day,

Need some help for the workflow on getting the range field based on the country data selected for example there are multiple country in source file then I only want to captured 1 country and also get the fields needed like 7 fields included.  How can I dynamically select that desired country included the field range needed. See Attached Workflow.

[Christina_H · Accepted solution]

My solution is attached, it relies on knowing which row contains the country names.

[grazitti_sapna · Accepted solution]

@arjundelara , here is my solution containing dynamic rename and dynamic select tool. So if you are not aware of the fields containing data it will dynamically select columns based on the country you provide without knowing the schema.

[arjundelara]

Hi @Christina_H ,

This is great! I appreciate your help. I'll apply this logic on my current workflow. Thank you so much for the idea!

[arjundelara]

Hi @grazitti_sapna 

Great works! I have now an idea to remove unnecessary fields! Thank you so much,