Data sources with different upper/lowercase letters
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Dear Alteryx community, I joined data from two different excels, in one excel High and Low is in capital letters. How can I make it the same so that it will be counted as one? See the attached picture for details. Thx, Patricia
Solved! Go to Solution.
- Labels:
- Output
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Titlecase([_CurrentField_]) works
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Patricia,
The easiest way is to standardize the fields using a formula tool and a case function (like title case).
Here is the original structure:
And here is the formula tool using title case and the output:
Now the values will all fall under the same groups when you are doing your aggregations.
Hope this helps,
Tristan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Glad it has been resolved! Please mark it as solved for future users to find solutions.
Have a great week!
Tristan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Oh and remember that you can standardize case using the data cleansing tool too!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Great thank you for your help!
