Input selection Dynamically

Question

I have multiple input files (separtae file for each country)  and Mapping file.

Each country has separate file with different input structure.

User will select country from dropdown and upload associated country file (file browse tool).

Mapping file has the country name and what is the starting position (row no)  of the data.

How to use this dynamically?

Mapping File.xlsx

input_US.xlsx

input_UK.xlsx

LuckyRaju · Answer

I have attached only sample files. Each country has different file structure and no of columns will be differ.

Mapping file consists of some fields like data type and Field required (yes/no). Based on these mapping details, we need to perform other actions.

SPetrie · Answer

How often does your mapping file get updated?

What is the significance of the columns in it?

It looks like each country has the same number no matter the indicated column. You can proabably get away with a name:value pair for each country in a dropdown.

Use an action tool from the drop down to update the starting row in the file select.

example.yxzp