Concatenate two elements in Excel Template
Hi,
I want to know if there is a way to concatenate two elements from BI Publisher data template as one in Excel template. I know this can be achieved by changing the query to concatenate the fields. But I want to know the possibility in Excel template. We are using Oracle Applications : 12.1.3, BI Publisher Desktop 12.1.2.2
I have a huge query that calculates the value of two columns (Application and Course). In my report I have to show three columns, Application, Course and the third column which is a combination of both Application and Course. In my data template, I defined two different elements for the same value.