Generator - Entity Column Generator

Undraw File Manager

Generator - Entity Column Generator

About

A entity column generator is a column data generator that generates data from a specific provided csv file located in the entity connection.

If you want to provide your own data set, you can use the data set generator.

Example

How to generate data with an entity?

Arguments

The list of arguments that you can use in the data supplier are:

Name Description Default
name The name of the entity Name of the column
column The name of the column to the data from the entity Name of the column
locale The locale of the entity for entity localization en
meta-columns A map that links a local column to a metadata entity column Empty

List and storage

All entities are stored under the entity built-in connection

tabul data list *@entity
path        media_type
---------   ---------------
country     inode/directory
firstname   inode/directory
gender      inode/directory
lastname    inode/directory
prefix      inode/directory
region      inode/directory
subregion   inode/directory

And every entity may have one or more locale

Example for the firstname entity

tabul data list firstname/*@entity
path                         media_type
--------------------------   ----------
firstname/firstname_ca.csv   text/csv
firstname/firstname_de.csv   text/csv
firstname/firstname_en.csv   text/csv
firstname/firstname_es.csv   text/csv
firstname/firstname_fr.csv   text/csv
firstname/firstname_gd.csv   text/csv
firstname/firstname_hu.csv   text/csv
firstname/firstname_it.csv   text/csv
firstname/firstname_nl.csv   text/csv
firstname/firstname_pl.csv   text/csv
firstname/firstname_pt.csv   text/csv
firstname/firstname_sk.csv   text/csv
firstname/firstname_tr.csv   text/csv

What are Entities?

An entity is CSV file:

  • with a name that contains the entity and locale: entityName_locale
    • Example: firstname_en.csv are English first names.
    • The locale defaults to en if not provided
  • where the first column as the same name as the file
  • that
    • contains the value to return as first column
    • contains optionally a numeric weight factor column called probability, weight or factor to create a histogram (distribution)
    • contains optionally other meta columns (for example gender for a firstname)
    • is located under the entity connection

Example with the firstname_fr.csv entity file

tabul data head firstname/firstname_fr.csv@entity
The first 10 rows of the data resource (firstname/firstname_fr.csv@entity):
firstname   gender   probability
---------   ------   --------------------------
Aadam       M        3.14396359513727576E-7
Aadel       M        6.52081338250694231E-7
Aadil       M        0.000002142552968537995330
Aahil       M        2.44530501844010337E-7
Aakash      M        3.02752049902108036E-7
Aalia       F        4.77416694076401133E-7
Aaliya      F        0.000002422016399216864286
Aaliyah     F        0.000028086074783226330085
Aalya       F        0.000001490471630287301099
Aalyah      F        0.000002585036733779537844




Related HowTo
Undraw File Manager
How to generate data with a data set?

This howto will show you how to generate data with an data set generator. In these examples, we use a predefined csv entity file but you could any data resource such as : a sql table a sql query...
Undraw File Manager
How to generate data with an entity?

This howto will show you how to generate data with an entity generator. Example of a basic entity generator resource that uses the firstname entity to fill a firstname column You can see the output...
Undraw File Manager
How to retrieve a third column from a data set generator ?

This howto will show you how to use the data set meta generator to retrieve a meta column (ie third column) from a data set defined in a data set generator (ie data set or entity generator) In this...
Undraw File Manager
SQL - How to execute SQL DDL statements (CREATE, ALTER, ..)?

This howto will show you how to execute a SQL DDL query that contains multiple: DDL statements (ie CREATE, ALTER) and an DML (INSERT) The file containing this query is located below the howto...

Task Runner