<ul><li>The problem is to convert a crosstab table containing product style data, width, length, and price information to a row-based table.</li><li>The solution suggests using SPL XLL to perform the conversion. The SPL code provided performs column-to-row conversion based on the style column and renames it to 'Length'.</li><li>The original column names are transferred as values in the new 'Width' column, and the cross cell values are transferred as values in the new 'Price' column.</li><li>The code further selects rows with non-null price values, sorts them by width and length, and creates a new dataset with 'Width*Length' as values in the 'Style' column.</li></ul>

#135 — Convert Crosstab to Row-Based Table

Discover more