# Script examples
## Example: Append new records to a table
{% hint style="info" %}
\#FlowScript #[Join](https://help.novacuraflow.com/6.12/development/flow-studio/table/table-functions#the-join-function) #[If statement](https://help.novacuraflow.com/6.12/development/flow-studio/statements#conditional-statement) #[For loop](https://help.novacuraflow.com/6.12/development/flow-studio/statements#loops) #[With](https://help.novacuraflow.com/6.12/development/flow-studio/table#update-row-the-with-keyword) #[Table concatenation](https://help.novacuraflow.com/6.12/development/flow-studio/table#insert-row-the-table-concatenation-and-operator) #[Create table](https://help.novacuraflow.com/6.12/development/flow-studio/table#create-table-the-empty-table-statement)
{% endhint %}
This scrip creates a new table and fills it with data from an already existing table, where one column will be updated with new data.
#### **Input table:**
*DS\_periodDates*
| date | dayStatus |
| ---------- | ---------------------- |
| 2019-12-01 | Confirmed |
| 2019-12-02 | Reported |
| 2019-12-03 | 3 hours left to report |
| 2019-12-04 | 8 hours left to report |
*DS\_favorites*
| customerId | customerName | project | accountDate |
| ---------- | ------------ | ------- | ----------- |
| 3245 | abc | 4565 | 2019-12-01 |
| 2456 | adc | 5465 | 2019-12-01 |
| 5974 | acb | 4564 | 2019-12-01 |
#### **Script:**
```fsharp
let generatedFavorites = table(customerId, customerName, project, accountDate, objversion, objid);
for recDate in DS_periodDates do
if recDate.date < now() and (recDate.dayStatus like '%hours left to report' or recDate.dayStatus = 'Reported') then
for recFavorite in DS_favorites do
let addedFavs = recFavorite with [accountDate: recDate.date];
set generatedFavorites = generatedFavorites & addedFavs;
done
end
done
return generatedFavorites;
```
**Description:**
1. A new table is created: *generatedFavorites* (row 1 in script below)
2. The script will loop for every row in table *DS\_periodDates* (3) where the date is in the future and the day status is like '%hours left to report' or 'Reported' (5)
1. The script will loop for every row in table *DS\_favorites* (7) where the account date in *DS\_favorites* will be updated with the date from *DS\_periodDates* (9)
2. The script adds the result from each loop iteration to *generatedFavorites* by concatenating the row with table *addedFavs* (11)
3. The script returns *generatedFavorites* (19)
#### **Output table:**
*generatedFavorites:*
| customerId | customerName | project | accountDate |
| ---------- | ------------ | ------- | ----------- |
| 3245 | abc | 4565 | 2019-12-02 |
| 2456 | adc | 5465 | 2019-12-02 |
| 5974 | acb | 4564 | 2019-12-02 |
| 3245 | abc | 4565 | 2019-12-03 |
| 2456 | adc | 5465 | 2019-12-03 |
| 5974 | acb | 4564 | 2019-12-03 |
| 3245 | abc | 4565 | 2019-12-04 |
| 2456 | adc | 5465 | 2019-12-04 |
| 5974 | acb | 4564 | 2019-12-04 |
## Example: Join in to a record
{% hint style="info" %}
\#FlowScript #[Join](https://help.novacuraflow.com/6.12/development/flow-studio/table/table-functions#the-join-function) #[If statment](https://help.novacuraflow.com/6.12/development/flow-studio/statements#conditional-statement)
{% endhint %}
This script joins values and assign the values to new variables.
#### Input variables:
#### Script:
```fsharp
let criticalBugsNoTeamJoinedKey = '0';
let criticalBugsNoProgressJoinedKey = '0';
let criticalBugsNotStaredJoinedKey = '0';
if count(criticalBugsNoTeam) > 0 then
set criticalBugsNoTeamJoinedKey = Join(criticalBugsNoTeam.key,'%27%2C%27');
end
if count(criticalBugs) > 0 then
set criticalBugsNoProgressJoinedKey = join(criticalBugs.key,'%27%2C%27');
end
if count(criticalBugsNotStarted) > 0 then
set criticalBugsNotStaredJoinedKey = join(criticalBugsNotStarted.key,'%27%2C%27');
end
let joined= [criticalBugsNoTeamJoinedKey: criticalBugsNoTeamJoinedKey, criticalBugsNoProgressJoinedKey: criticalBugsNoProgressJoinedKey, criticalBugsNotStaredJoinedKey: criticalBugsNotStaredJoinedKey];
return joined;
```
#### Output variable:
## Example: Convert a complex table into a simple table
{% hint style="info" %}
\#FlowScript #[Join](https://help.novacuraflow.com/6.12/development/flow-studio/table/table-functions#the-join-function) #[Loop](https://help.novacuraflow.com/6.12/development/flow-studio/statements#loops) #[For loop](https://help.novacuraflow.com/6.12/development/flow-studio/statements#loops) #[Create table](https://help.novacuraflow.com/6.12/development/flow-studio/table#create-table-the-empty-table-statement)
{% endhint %}
This script will create a simple table where for example join is used to join all components together in to one string so all values can be put in to one column.
#### Input table:
The input table *blockerBugsFiltered* is a complex table with differnt levels of tables, records and simple values in the table.
#### **Script:**
```fsharp
let blockerBugs = table (key, summary, description, priority, components, assignee, created);
for rec_ in blockerBugsFiltered do
let joinComponents = join(rec_.fields.components.name, ', ');
set blockerBugs = blockerBugs & [key: rec_.key, summary: rec_.fields.summary, description: rec_.fields.description, priority: rec_.fields.priority.name,
components: joinComponents, assignee: rec_.fields.assignee.displayName, created: left(rec_.fields.created,10)];
done
return blockerBugs;
```
**Description:**
1. A new table is created: *bockerBugs* (row 1 in script below).
2. The script will loop for every row in table *blockerBugsFiltered* (3).
3. Join the values in the *components* table (5).
4. Append new records to table *blockerBugs* (7).
5. The script returns the table *blockerBugs* (12).
#### Output table:
The output of this script will be a simple table including only simple values.
