KNOWLEDGE BASE

"The field '[xxx]' in the datasource 'relation' does not exist in your database. It was either modified or removed" Error Occurs when Converting Time-only Field to String Type in Wildcard Union


Published: 29 Sep 2021
Last Modified Date: 29 Sep 2021

Issue

The following error might occurs when converting time-only field to string type after wildcard union several flat files.
"The field '[xxx]' in the datasource 'relation' does not exist in your database. It was either modified or removed"

for example
User-added image

Environment

  • Tableau Desktop 2021.2.1
  • Text Files

Resolution

Workaround 1

1. Turn on data interpreter before union your data.
2. Wild card union your data
3. Change the data type after the wildcard union

Workaround 2

Use manual union instead of wildcard union.
 

Cause

This issue is being investigated by Tableau development under ISSUE ID 1314458.
Did this article resolve the issue?