concatenate data elements with line break in BI excel template
Summary:
<?concat(.//SUPP_NAME,';',.//SUPP_NAME2,';',.//SUPP_NAME3)?> It is concatenating with supp_name,supp_name2,supp_name3 columns separated by ',' .
In my case comma "," also displaying for null cases.
Hence i am trying to display with line breaks in the excel templates.
Below syntax didnt work:
<?concat(.//SUPP_NAME,chr(10),.//SUPP_NAME2,chr(10),.//SUPP_NAME3)?>
Please suggest
Content (please ensure you mask any confidential information):
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):
Tagged:
0