DV TEXTAGG excludes column from the result if it is blank
Issue
- TEXTAGG function excludes the column from the result if it is blank
TEXTAGG(FOR Last_Name,First_Name,Middle_initial,Currency_Code DELIMITER '|' QUOTE '"')
In the above example,if middle name is blank, then it should still show one empty column with "|" delimiter as shown below:
Smith|John||USD
But it returns output excluding middle name since it is blank:
Smith|John|USD
Environment
- Red Hat JBoss Data Virtualization (DV) 6.2
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.
Close
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.