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

Question

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.

Get the specific field based in the cell value.yxmd

Christina_H · Accepted Answer

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

grazitti_sapna · Accepted Answer

@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.