Updating records
- 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
Hi,
I've a dataset below and I would like to update the rows that only have one decimal place e.g. "1.1" "1.2" etc.
It is based on a RAG status and if any of the records contains a RAG status that is "below" the one in the "main" row it should be updated accordingly.
E.g. if "1.1.2" contains Amber then "1.1" should be updated to Amber.
Number | Colour |
1.1 | Green |
1.1.1 | Green |
1.1.2 | Amber |
1.1.3 | Green |
1.2 | Amber |
1.2.1 | Red |
1.2.2 | Green |
1.3 | Amber |
1.3.1 | Red |
Below is the table with the updated values (rest remains the same)
1.1 | Amber |
1.2 | Red |
1.3 | Red |
Many thanks,
Pav
Solved! Go to Solution.
- Labels:
- Preparation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I guess this is identical in logic to that of @jdunkerley79, except it uses formulae instead of parse tools and lookup tables; thought I would post it as just another way to do the same thing.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I like @JohnJPS approach as well, one other idea is to use a sort (by NumberOut Asc, ColourInt Desc) and then a sample (take first 1 for each NumberOut). No need for summarise then
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
This is amazing, thank you both. Really helped me here