Designer Cloud Powered by Trifacta Educational
Page tree


Support | Blog | Contact Us 

Versions Compared

Old Version 17

changes.mady.by.user docuser1

Saved on

compared with

New Version Current

changes.mady.by.user docuser2

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version next

D toc

Excerpt

D s lang
 supports a set of variables, which can be used to programmatically reference aspects of the dataset or its source data. These metadata references allow you to create individual transformations of much greater scope and flexibility.

Tip

Tip: Some transformation steps make access to metadata about the original data source impossible to retain. It's best to use these references, where possible, early in your recipe. Additional information is available below.

...

D trans
RawWrangletrue
Typestep
WrangleTextset col: * value: IF(ISMISMATCHED($col, ['String']), $col, UPPER($col))
p01NameColumns
p01Value*All
p02NameFormula
p02ValueIF(ISMISMATCHED($col, ['String']), $col, UPPER($col))
SearchTermEdit column with formula

...

Tip

Tip: $col is useful for multi-column transformations.


D s also
inCQLtrue
label((label = "datasets") OR (label = "metadata"))

© 2013-2023 Alteryx® Inc. Privacy Policy  |  Terms of Use