This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!
Submit FeedbackLooks like @NicoleJohnson and I had very similar thinking here. Eliminating certain tools gives things an interesting spin.. 🙂
@ggruccio I like what you did with the concat, gives me an idea!
Just the easy way for now
@GarthMiles @DataPrepChad, you guys went the direction I was hoping to see someone try out! Lots of variety this week!
Finally used a tool that I've seen a ton but haven't had the opportunity to use. Made the hard way quite a bit easier!
Ugh, @JoeM...I loathe the Dynamic Replace tool (mostly 'cuz I still need the help doc to guide me through setting it up).
The best advice I ever received for configuring this tool is to write out the "Boolean" and "Output" expressions in 2 (or more) Multi-Field Formula tools (1 expression per "multi-field" tool) to check that the syntax+logic make sense.
Then...copy/paste those expressions into a Formula tool (1 for "boolean", 1 for "output", etc.) and wrap'em in quotes.
Once everything works as expected...run garbage collection (i.e., delete all multi-field tools from canvas) and pretend you worked through it all in your head!!