This weekly challenge takes a look at creating unique combinations. This is a common requirement when you append many similar fields together. Chris provides a walkthrough of this weekly challenge, which not only is built ...
Use Case: Another useful design pattern to have at your fingertips is the ability to parse out a single row of a value(s) into multiple rows BUT—and this is the caveat that makes it all ...
Use Case: I have come across many scenarios where there just isn’t a nice simple clean way to filter on numerous columns AND records. Now if you read my previous post you learned about how ...
Use Case: I have spoken with many users tasked with parsing HTML or XML data, serialized data, or even unstructured data, and many of them end up doing this task with 10-20 tools just to ...
Use Case: You want to know something can work (ie test) or you want to get started on a project or keep moving while data at the source might have a problem that is being ...
Use Case: You have data with multiple columns that might either be null or have a specific value that you don’t want. An easy way to dynamically get rid of those columns is to use ...
For today’s design pattern, Chris is going to show you how using a combination of joins, filter and append tools can be use to perform a validation test in the workflow to ensure that data ...