How do I rename some of my data inputs?
- 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
How do I make my dataset such that all items called "Shoe and boxes" are labeled "Shoes and boxes" instead?
In other words such that the first table becomes the second table?
I have tried several if formulas, but without luck. I am a real newbie, and appreciate your kind help! :)
Item | Price |
Trouser | 100 |
Shoes and boxes | 30 |
shoe and boxes | 10 |
Jeans | 100 |
Top | 90 |
Shoe and boxes | 30 |
Item | Price |
Trouser | 100 |
Shoes and boxes | 30 |
Shoes and boxes | 10 |
Jeans | 100 |
Top | 90 |
Shoes and boxes | 30 |
Solved! Go to Solution.
- Labels:
- Preparation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Will the following formula work:
IIF([Item]=="shoe and boxes","Shoes and boxes",[Item])
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey @klaraklara!
Are these the only combinations of shoes/shoe and boxes in your whole data set? If so, you can add a formula with the following expression:
iif([Item]="shoe and boxes" || [Item]="Shoe and boxes", "Shoes and boxes",[Item])
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
If you have many such cases I tend to favour a lookup table, which you can perform a join on to return the true value for each item.
Another option, which probably isn't a good place to start as a newbie is the 'fuzzy match' tool which has great capability to match objects that are similar in name.
Ben
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@klaraklara yet another option, very similar to what @BenMoss said, would be to use a Find Replace tool.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you so much! it was very helpful!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
How would you type the formula in if there are multiple combinations?
