Converting Column values into Rows - RTF Template

Sakthinps · Jan 11, 2017 8:00AM

Summary

Dear Friends,

I have a requirement in RTF Template to convert the column values into rows based on an Account_Number.

For example, Account_Number 001 has Year values as 2011, 2012, 2013, 2014, 2015, 2016.

As using the source as SQL Query, it comes to RTF template as like below.

Account_Number Year

---------------------- ------

001 2011

001 2012

001 2013

001 2014

001 2015

001 2016

But the requirement is to display the value as below.

2011, 2012, 2013, 2014, 2015, 2016

I dont want to display the account number.

Please help me to achieve this, I stuck here for long time.

Any help would be appreciated.

Thanks.

Venkat Thota - BIP · Jan 11, 2017 8:00AM

best way is to do at sql query side ,if you can't do ,send me query with sample data.

or you can do at template level ,send me rtf and xml,will send you modified one.

Follow below link at template level

Thanks

nm.Mani · Jan 13, 2017 8:00AM

hi,

have you tried pivot option and hide the account column?

thanks

MM