- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
Hi,
This isn't possible with ordinary ootb query activities.
Alternative options in descending order of maintainability:
- Use sql or js activity to alter the temp table's structure and populate it with substrings
- Write substrings to a file then load them into workflow with Data loading (file) activity formatted with long text col
- Create a permanent temp schema with big string col and in workflow truncate then use Update data activity to write substrings to it, with outgoing transition (replaces enrichment)
- Create your own temp schema in the workflow in js with undocumented registerSchema(), setSchemaSqlTable(), buildSqlTable(), etc.
Thanks,
-Jon