Columns to Rows

Hi @Raj Yalaka,

if I understand correctly, you just need to take the first data line (or 2nd line if we include the header line) of your input table (values that look like years) and transpose it to a 3 column output with column names: Period, Pilot, Vermont.

I suggest you build the following step composition in your plan/component:

1. Text File Reader to read your CSV
2. Alter Format to “add_output_columns” with the relevant output names and data types (add Period, Pilot, Vermont)
3. Multiplicator step (name it e.g. “fork_periods”)
4. set of Column Assigner steps for each mapping of the input column (name it e.g. map_yr1, map_yr2, map_yr3, ...) - add as many Column Assigners as you need to map the triplets of your output attributes inside each Column Assigner step using the following 3 assignments:
   1. map Pilot_Yr1 attribute to output attribute called Pilot
   2. map Vermont_Yr1 attribute to output attribute called Vermont
   3. map a respective string constant “Yr1” to output attribute called Period (don’t forget to adjust the constant when copy&pasting the CA Steps, and check the same for Pilot and Vermont mapping)
5. Union Same - merge all the flows from your Column Assigners to a UnionSame step (not just plain Union) and name it e.g. sink_periods
6. Use the union flow as you need / e.g. Text File Writer

This way you “generate” the additional lines you need from your “single” line input. What is not entirely clear to me is the first data line in the output table with

Maybe you will need another specific Column Assigner step to map it with this content as a static text (similar to Period mapping above).

Hope this helps.

Regards,

Petr