DocumentationUser The Flow ToolWhat Process Types are available?

What Process Types are available?

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

TMMData - my.tmmlog.in - Google Chrome

1. Search Process(es) 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, we can explore the choices under Type:

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

Notice the options available under Method:

TMMData - my.tmmlog.in - Google Chrome

Make your entries or selections, then click Save.

TMMData - my.tmmlog.in - Google Chrome
5. Custom Python

Select from the available Python Versions.

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

"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
TMMData - my.tmmlog.in - Google Chrome
9. Deduplication

Notice that we can make a few choices:

    1. Select All - all Fields will be Deduplicated.

    2. Or, select the specific Field(s) - to be Deduplicated.

TMMData - my.tmmlog.in - Google Chrome

Select to Merge or Remove the Duplicates.

TMMData - my.tmmlog.in - Google Chrome

Select the Merge Method to be used.

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

Complete any entries or selections needed, then click Save.

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

For this From Table example, we need to select a Method to be used: Insert or Update.

TMMData - my.tmmlog.in - Google Chrome
TMMData - my.tmmlog.in - Google Chrome
  • Notice that the selected From Table has the Fields grayed-out (so no selections can be made on them).
  • Notice that the To Table has Fields that are available to "Select option(s)" for.

Once you've completed your selections and entries, click the Save button.

13. To Table
TMMData - my.tmmlog.in - Google Chrome
  • Note: The selected To Table will have Fields that ARE available to "Select option(s)" for.
  • Note: The From Table will have the Fields grayed-out (so no selections can be made on them).

After your selections and entries have been made, click the Save button.

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.

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

Make your selections, then click the Save button.

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

Once you have made your selections, click the Save button.

17. Refresh Custom Field(s)
TMMData - my.tmmlog.in - Google Chrome

Once you have made your selections, click the Save button.

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

Once you have made your selections, click the Save button.

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

Once you have made your selections, click the Save button.

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

Once you have made your selections, click the Save button.

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

Once you have made your selections, click the Save button.

22. Transform
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
TMMData - my.tmmlog.in - Google Chrome

Once you have made your selections, click the Save button.

23. Truncate Table

Select a specific table (#4 in the image) to have the Truncate applied to.

TMMData - my.tmmlog.in - Google Chrome

Once you have made your selections, click the Save button.

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

Once you have made your selections, click the Save button.