Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 15 Next »

Overview

Scripts can run separately from transformations. You can, for example, create a script that truncates a database table before you run a transformation to fill it again. You can also create scripts with logic you will use in several mappings in transformations. You can run scripts using the RunScript() function, or by inserting them into an operation.

Frequently Asked Questions

Q: How do you randomly generate a number using scripting?

A: The following are examples to generate a random number, depending on your use case. For additional information, please go to Formula Builder General Functions.

EXAMPLE:

  1. Random(0, 9999999);
  2. RandomString(7, "0123456789")

Q: How do you validate an e-mail address?

A: If(RegExMatch(emailaddress,"[A-z0-9._%+-]+@[A-z0-9.-]+\.[A-z]{2,4}")

Pages in this Category

  • No labels