Having a bit of a difficult time with this one. I'm new to Alteryx and still learning the ropes.
Based on the data contained in one column of my workbook, I need to create another column with different data. For example:
| Country | Year |
USA | 2015 |
| USA | 2016 |
| France | 2016 |
| Japan | 2015 |
| USA | 2014 |
What I would like to have is something that looks like this:
| Country | US or Non-US | Year |
| USA | USA | 2015 |
| USA | USA | 2016 |
| France | Non-US | 2016 |
| Japan | Non-US | 2015 |
| USA | USA | 2014 |
I tried to look for a formula that would create values in a new column (US or Non-US) based on the values in the Country column, but I can't seem to figure it out. Any help would be greatly appreciated!
Megan
