Data Caterer
Home
Connection
Plan
History
Shutdown
Create new plan
Plan name
Plan name required
Save
Delete Data
Execute
Expand all
Collapse all
Tasks
+ Task
Relationships
Define relationships between columns across any task to ensure values remain consistent.
Example
Report
Advanced Configuration
Relationship Example
For example, you have a
'create-accounts'
task which will create records with column
'account_id'
in a CSV file. Another task called
'create-transactions'
will also have the column
'account_id'
but in a JSON file.
Source:
Task: "create-accounts", Columns: "account_id"
Links to:
Task: "create-transactions", Columns: "account_id"
With relationship
Accounts
account_id
status
open_date
ACC123
Open
2023-01-01
ACC789
Closed
2023-02-21
Transactions
account_id
amount
ACC123
12.34
ACC789
105.45
Per Unique Column Values Example
For example, we generate transactions with the columns
'account_id,name,date,amount'
. We can generate multiple transactions per unique
'account_id,name'
.
Below, we set
3 records per unique
'account_id,name'
values
.
With per unique column values
Transactions
account_id
name
date
amount
ACC123
Peter
2023-01-01
12.34
ACC123
Peter
2023-01-04
67.89
ACC123
Peter
2023-01-15
102.98
ACC789
John
2023-02-01
105.45
ACC789
John
2023-02-12
59.14
ACC789
John
2023-02-25
73.56