Requirement - We are in need of generating report with 6/7 column out of which first column is Company Name & Its Website combined. While displaying data Website URL should be below Company Name and the rest of the columns should be on the same first row as Company name. Essentially first column needs to show Company name on first line and website on the next line
Problem & Solution tried -
1. Use of \n character with string concatenation - it did not work.
2. With the use of adding spaces in between company and website using PadRight, we tried to achieve this but Alteryx is automatically showing record in the same row if the company name and website combined can fit in that column and it automatically ignores the spacing. If the column width (without spaces) cannot accommodate Alteryx shows it in a different row. But we need this behavior for all data.