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.

5. Custom Python

Select from the available Python Versions.

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
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.

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

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

15. Slack

Make your selections, then click the Save button.

16. Refresh SQL Field(s)

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

17. Refresh Custom Field(s)

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

18. Refresh Table

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

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

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

20. Run Data Process

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

21. Run Export

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

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.

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

24. Flip Data

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