Issue
When using "Edit Value" or "Group Values" (Group and Replace in previous versions) to replace values in a lot of fields, log files grow very large (up to 30GB in some cases) and sometimes causes the machine to hung.
Last Modified Date: 16 Oct 2020
Environment
- Tableau Prep Builder 2019.4.1 or later
Resolution
WorkaroundUse calculation field instead of "Replace".
For example:
To replace null with zero - Create a calculation field and use ZN().
To replace 'AAA' with 'Good' - Create a calculation filed and use "IF [column] = 'AAA' THEN 'Good' ELSE [column] END"
Cause
The log files can grow large for following reasons:1. The query is very large.
2. It takes longer to execute and process a large number of requests that poll for the status of the execution, which causes a lot of records to be added in the logs.
Remap works better for modifying a large number of values in a single column, but not optimized for replacing values across many columns.
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials