Use the SQL Statement generator to define data to import from an external database using a SQL statement. This expression offsets values from a table's BookingTime column by intervals of 20 minutes between 6am and 9am: (random.choice()).AddMinutes(random.choice()) SQL Statement generator The expression generates the values Pass or Fail. This expression uses a table's ExamScore column to determine if a student has passed or failed an exam: "Pass" if ExamScore <= 75 else "Fail" This expression adds 100 days to values in a Date column: Date.AddDays(100) The expression generates the values True or False. This expression uses a table's BirthDate column to determine if a person is eligible to vote: (DateTime.Now - BirthDate).TotalDays/365 > 18 Now, AddHours, AddDays, AddMonths, TotalDays Example expressions You can also use the following C# DateTime methods with the Simple expression generator: You can use Python functions with the Simple expression generator, including:įactorial, log, pow, sqrt, sin, cos, tan C# methods If you want to write an expression that's more than one line, we recommend you use the Python script generator. Values are specified for the following keys: config is a dictionary that contains values you can use in your scripts. main(config) functionĪ script must define a main() function that takes a single config argument. Use the Python script generator to define the generated data using an IronPython script. If you have a very long list of values, you may want to consider creating a CSV file with the list of values and then importing the values using the CSV generator to import the values. You can then browse to this file when you select the File List generator. The values will be imported from the list in a random order. You must first create a text file containing the list of values, with each value on a new line. Use the File List generator to import values from a text file. If you specify large files, or if you specify a large number of files, performance will be reduced. You can specify a search string to identify the files within the specified folder you want to use. Use the File Import generator to import the contents of files in a specified folder.įor example, if you specify a folder containing a number of images, each image is imported into a new row. (If you want to import data from a CSV file into an entire table or multiple columns in a table, you can use the Use existing data source table generation setting instead for details, see Mapping CSV files.)Ĭlick Browse to select the CSV file you want to use you then specify the delimiters to be used when importing the data, and select the column in the CSV file that you want to import. Use the CSV generator when you want to import data from a CSV file into a single column.
#Csv data generator how to
Information about each of these generators is provided below.įor information about how to customize the generators, see Customizing existing generators. SQL Data Generator provides the following generators in the Generic category for you to customize:
0 kommentar(er)
