I have some varchar data fields defined in Oracle DB and tableau is consuming those data fields though a view made on the table. But when i am dropping these varchar columns on the rows shelf , the values are being displayed as NULL , while the view query in database is returning proper values for the columns. Any idea what might be getting wrong here?
It is possible the varchar dimension has a leading whitespace. If you create a new calculated field using the TRIM() function, so something like TRIM(<varchar field>), do the values show up when you drag the calculated field to Rows?