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, tools, and much more.