I'm new to DSS and trying to work around the pivot in prepare recipe.
Sample test case:
The first 2 tables show the sample input and output that I require. The third image shows the setting I've applied on my the pivot formula.
Real case scenario:
Multiple characteristic columns to pivot on e.g. Company, Company type, Company Location etc.
12 unique values in the "Month" column.
I've applied the pivot step by step on all the characteristic columns. On running the particular recipe I am getting a blank output. Also, only 4 out of the 12 unique values are visible in the column headers. Any clue as to what I'm doing wrong?