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.
I'd like to create a new column in my data that contains a month string based on user input from a drop down. My data is a fairly simple Excel file with 3 columns (id, unit and counts). This data is run monthly and I need to add the month (in the form Jan, Feb, Mar....) in a column each time this data is run.
I thought it would be easy to use a dropdown tool to list the months, have the user choose the appropriate month and then have this month column appended to the data. But, I consistently get an error or "No Output Files". I've tried many variations on strings. I've tried using numbers and converting to months. I'd appreciate any help.