Foundation Documentation and SupportV6 User Manual The Flow ToolWhat Process Types are available? (Version 1.0)

What Process Types are available? (Version 1.0)

1. Under the "Process(es)" Tab, click the "+" button to add a Data Process...

TMMData - my.tmmlog.in - Google Chrome

1. "Search Processes" box - Helps to narrow down the search results, based on the name of the process(es)

2. "Add Process" Button - Opens a menu with the various options for the Process(es):

 

TMMData - my.tmmlog.in - Google Chrome

After clicking the "Add Process" button, notice that there are a lot of choices under the "Type"...

We can see 8 of those choices in this image...

TMMData - my.tmmlog.in - Google Chrome

We can see choices 9-16 in this image...

TMMData - my.tmmlog.in - Google Chrome

And we can see choices 17-24 in this image.

TMMData - my.tmmlog.in - Google Chrome

We will go into more detail about the 24 available options:

1.2. Call URL
TMMData - my.tmmlog.in - Google Chrome
TMMData - my.tmmlog.in - Google Chrome

Notice the options available under the "Method" drop-down menu...

TMMData - my.tmmlog.in - Google Chrome
1.8. Delete Records
TMMData - my.tmmlog.in - Google Chrome

Notice the "Warning: This will remove ALL records."... only use the "Delete Records" if you intentionally want to remove ALL records.

TMMData - my.tmmlog.in - Google Chrome
1.9. Deduplication
TMMData - my.tmmlog.in - Google Chrome

Notice that we can make a few choices:

1. "Select All" Fields to have the Deduplication applied to...

2. Or, select the specific Field(s) to have the Deduplication applied to...

TMMData - my.tmmlog.in - Google Chrome
TMMData - my.tmmlog.in - Google Chrome
TMMData - my.tmmlog.in - Google Chrome
TMMData - my.tmmlog.in - Google Chrome
1.12. From Table
TMMData - my.tmmlog.in - Google Chrome
TMMData - my.tmmlog.in - Google Chrome
TMMData - my.tmmlog.in - Google Chrome

Notice that the selected Table (1) has the Fields grayed-out (so no selections can be made on them)... because this is the "FROM TABLE" process...

also notice that the Table (2) has Fields that are available to "Select option(s)" for...

Once you've made your selections, click the "SAVE" button.

1.13. To Table
TMMData - my.tmmlog.in - Google Chrome
TMMData - my.tmmlog.in - Google Chrome

Notice that the selected Table (1) has Fields that ARE available to "Select option(s)" for... because this is the "TO TABLE" process...

also notice that the Table (2) has the Fields grayed-out (so no selections can be made on them)...

After your selections have been made, click the "SAVE" button.

1.14. Notification
TMMData - my.tmmlog.in - Google Chrome
TMMData - my.tmmlog.in - Google Chrome
TMMData - my.tmmlog.in - Google Chrome

Once you have made your selections, click the "SAVE" button.

1.15. Slack
TMMData - my.tmmlog.in - Google Chrome

Make your selections, then click the "SAVE" button.

1.16. Refresh SQL Field(s)
TMMData - my.tmmlog.in - Google Chrome

Notice that the Table (1) shows up as the default Table (2)... but you still have the drop-down menu option available to select a different Table if wanted...

Once you have made your selections, click the "SAVE" button.

1.18. Refresh Table
TMMData - my.tmmlog.in - Google Chrome
TMMData - my.tmmlog.in - Google Chrome

Once you have made your selections, click the "SAVE" button.

1.19. Retry
TMMData - my.tmmlog.in - Google Chrome
TMMData - my.tmmlog.in - Google Chrome
TMMData - my.tmmlog.in - Google Chrome

Once you have made your selections, click the "SAVE" button.

1.20. Run Data Process
TMMData - my.tmmlog.in - Google Chrome
TMMData - my.tmmlog.in - Google Chrome

Once you have made your selections, click the "SAVE" button.

1.21. Run Export
TMMData - my.tmmlog.in - Google Chrome
TMMData - my.tmmlog.in - Google Chrome

Once you have made your selections, click the "SAVE" button.

1.22. Transform
TMMData - my.tmmlog.in - Google Chrome
TMMData - my.tmmlog.in - Google Chrome

Notice that we can:

1. "Select All" Fields...

2. Or, we can select the specific Field(s) to have the Transformation applied to...

TMMData - my.tmmlog.in - Google Chrome

Once you have made your selections, click the "SAVE" button.

1.23. Truncate Table
TMMData - my.tmmlog.in - Google Chrome

Notice that the Table (1) becomes the default selection in Table (2)... but you can also select another option, if wanted...

Once you have made your selections, click the "SAVE" button.

1.24. Flip Data
TMMData - my.tmmlog.in - Google Chrome

Once you have made your selections, click the "SAVE" button.