By default, scripted tables added in the data load editor cannot use the tools available in Data manager. For example, you cannot associate scripted tables with other tables in Data manager or transform fields in scripted tables using the data profiling cards. If you synchronize your scripted tables in Data manager, you can replace your scripted tables in Data manager with managed scripted tables. These tables have access to all the same tools as tables added in Data manager, including:
- Editing tables, such as adding calculated fields.
- Transforming fields, such as changing the field types or transforming fields with data profiling cards.
- Transforming tables, such as unpivoting or concatenating tables.
Synchronization and managed scripted tables have the following limitations:
- Scripted tables must be located before the Auto-generated section in the data load script to be synchronized as managed scripted tables. Tables after the Auto-generated section in the data load script will not be synchronized.
- You cannot use Select data from source to change the selection of fields in a managed scripted table.
Do not synchronize your scripted tables if your data load script contains an Exit statement or dynamic fields.
To convert your scripted tables into managed scripted tables, synchronize your scripted tables in Data manager. Synchronization does the following:
- Replaces all synchronized scripted tables as managed scripted tables.
- Deletes any managed scripted tables whose scripted tables have been removed in the data load script.
Updates any managed scripted tables whose source tables were changed in the data load script.Warning:
If you have synchronized tables, you should not make changes in the data load editor with Data manager open in another tab.Warning:
Avoid changing the data load script for tables already synchronized in Data manager. If you remove or modify fields in data load editor, you must delete or redo any derived fields or associations in the synchronized table. Derived fields using a removed or modified field, such as a calculated field or fields created by the Split card, display null values.
After synchronization, you can use the managed scripted tables in Data manager like any other table. Data manager prompts you to synchronize again if it detects differences between a managed scripted table and the source scripted table.
To change managed scripted tables back into scripted tables, delete them in Data manager. You must repeat the deletion if you synchronize again.
Synchronizing scripted tables
Do the following:
In Data manager, click ¥.
Alternatively, select a scripted table.
Click Synchronize scripted tables.
Managed scripted tables replace all the scripted tables in Data manager.
Removing managed scripted tables
Do the following:
- In Data manager, select Tables view.
- On the managed scripted table you want to remove, click Ö.
- Click Load data.
The managed scripted table changes back to a scripted table.