Challenge #160: Diamonds R Forever
- 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
my solution:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Wanted to try and join a lookup table to work like an approximate VLOOKUP, but struggled with it. Ended up with a formula based solution, but definitely curious if anyone finds a way to accomplish it via a similar method.
- 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
Fun challenge! I have used the R tool with an input tool, but not without an input.
The R code I used (I had already unzipped the file):
load("C:/Users/Christopher.Lewis/Save Location/Alteryx Challenges/Big Diamonds/BigDiamonds.Rda")
write.Alteryx(diamondsbig, 1)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Took a little bit of time to read and comprehend the link to using the R tool. Learning R and Python coding are on my list.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I got to show this to the wife, since she is a gemologist and diamond grader 😊
It took me some serious time to solve this one.
Struggled with the reading of the rda file, seem I was not the only one who quite didn't get how to use slashes properly.
Second was the grouping. At first I hadn't seen the provided Output, so I just went for the quick and easy Smart Tile.
But just before I was to submit the answer I noticed the Output, and found out, that it was not that easy after all 😉
In order to save some time, and avoid to read the data from the rda file, every time the workflow is run, then I simply added a Select tool and choose »Cache and Run Workflow«
The on all the subsequent runs, the workflow would run a little bit faster 😉
Still Climbing
/Verakso
- 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
- 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
Had to dust off some long-unused R syntax for this one!