This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
1) derive Drop Down options from Text Input tool (there is a little trick here to Cross Tab values to field names and only this can feed into Drop Down tool from same workflow - there are other ways this info can be provided from, depending on your setup)
2) Update Cell from the selection and only output this in the output file (with the above trick, Cross Tab enforces '-' character as '_', so to match the original values this is reverse engineered using the Formula tool)