With the excel tool you can specify multiple values in a column by seperating the values with a '||'. This does not appear to work with the pAuthor tool. How do I accomplish this functionality with this tool?
Example: I have a "Products" column that lists all the products a solution requires to run. currently in my excel spreadsheet that column make look like this "Windows Server 2008 R2 || SQL Server 2008 || IE 8" and when
I use the Excel tool the CXML for "products" looks like this and the PivotViewer control handles it correctly:
<String Value="Windows Server 2008 R2" />
<String Value="SQL Server 2008" />
<String Value="IE 8" />
With pAuthor it looks like this:
<String Value="Windows Server 2008 R2 || SQL Server 2008 || IE 8" />
Do I need to do it different for pAuthor?