Pattern-Matching In SQL SELECT

Data Academy has had the ability to do a pattern-matched SQL SELECT in Un-Pivot transformations since version 5.6; but we've now added the same functionality to Regular transformations in Data Academy 6.

This means that you can select all columns matching a particular Regular Expression pattern, with a single swish of your Data Academy magic wand.

So the following RegEx expression:

^Col

... when combined with the following RegEx Target Field Name:


+.

... will output all columns beginning with Col - i.e. Col1, Col2, etc. - to a Target Field of the same name.