Question
Oracle NUMBER(38,0) is recognized as Number(Decimal) in Tableau Prep Builder, but it needs to be Number(Whole) to be set as incremental refresh input field.How to use Oracle NUMBER(38,0) column as incremental refresh input field?
Last Modified Date: 01 Jun 2023
How to use Oracle NUMBER(38,0) column as incremental refresh input field?
Environment
- Tableau Prep Builder
- Oracle
Answer
Use custom SQL to cast NUMBER(38,0) as NUMBER(18):CAST (column AS NUMBER(18))
Additional Information
For Oracle NUMBER[(precision [, scale])] column:1. When scale is not 0, the column is recognized as Number(Decimal)
2. When precision is over 18, the column is recognized as Number(Decimal)
2. When scale is 0 or not set and precision is not over 18, the column is recognized as Number(Whole)
Refresh Flow Data Using Incremental Refresh
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