Need help building a simple mapping file workflow

Question

Hi all! I have an Excel file and I need to create a mapping file based on states and description (Column titles: State, State Description, F Grouping). The mapping file will be the first 2 fields that I listed, and then the F Grouping column is will be empty (if that makes sense, because the other user adds the F Grouping field - not me). There are many tabs in the Excel file, but I am just focusing on one. One tab called Grouping has all the data I need. This tab has the states, state descriptions, and F grouping columns - so 3 total). Help on this would be greatly appreciated, as I have not done this before. Thank you!

ShankerV · Answer

Hi @slaurel

While importing, select the specific Sheet so that it will be helpful.

Post import you will have all the columns,

We are interested in only 2 columns, hence use select tool the remove the other from our mapping file

Using the formula tool, create the column F grouping where other users can add.

Hope this helps!!!

Many thanks

Shanker V

Need help building a simple mapping file workflow.yxmd