Page tree

Versions Compared

Key

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

...

Excerpt

This example illustrates how to use the IF* functions for data type validation.

...

Functions:

...

D generate list excerpts
pagesIFNULL Function,IFMISSING Function,IFMISMATCHED Function,IFVALID Function,MERGE Function

Source:

The following simple table lists zip codes by customer identifier:

...

D trans
RawWrangletrue
p03Value'status'
Typestep
WrangleTextderive type:single value:IFMISMATCHED(custZip, 'Zipcode', 'mismatched') as:'status'
p01NameFormula type
p01ValueSingle row formula
p02NameFormula
p02ValueIFMISMATCHED(custZip, 'Zipcode', 'mismatched')
p03NameNew column name
SearchTermNew formula

D s also
labelexample_if_data_type_validation_functions