Dynamic column name with dynamic select

[Saranyaram]

Can anyone pls help me with dynamic rename of values of header rows from column itself which is yearmonth like yyyy-mm upto 12 months in it with dynamic select at the output ..is this can be done ? Please do let me know .attached screenshot of sample data for your reference ..here I am trying to prepare the layout of previous year month data along with current month year data in side to side way in excel output ..this yyyy-mm field is derived column of another date column in source data

[jrlindem]

Thank you for opening this thread.  @Saranyaram  can you provide a fake dataset in excel format that matches your input and then again with the expected output format?  I think this should be relatively straight forward.  -Jay

[Saranyaram]

Attached sample output ..in this date column values has to be split to header rows and corresponding amount value has to be taken .and my source data present till amount values in excel

[jrlindem · Accepted solution]

@Saranyaram 

I’m still not sure I’m interpreting your need correctly.  Without providing how your data looks to begin with I can only guess at what you’re needing.

That said, I created a workflow that takes your data, converts it into what I think your data started as, and then converts it back.  In this way you can see how I’m going back and forth with the data format using Crosstab and Transpose Tools.

For Transpose, specifically, to get the fields to dynamically expand with new data, simply enable “Dynamic or Unknown Columns” so that as new values come in they are automatically added.

If this isn’t what you’re after (screen shots above and workflow attached), please include your starting data so a mock up can be built to show how that gets transformed into the output data you already included.

Thanks and I hope you find this useful, -Jay

[Saranyaram]

@jrlindem 

Thanks for the time ..your shared flow part i have derived already but the column marked in screenshot has to be dynamically created and take the names  dynamically to the output.for example if we run at first it might 2024 ,2025 data in source  date field and in second run it might have 2025,2026 etc .. how to configure the output with dynamic column everytime .could you please help me on that 

[jrlindem]

@Saranyaram This shouldn't be a problem so long as you start with a dataset that has some of the date names and then you check the Dynamic or Unknown Columns box on the Transpose Tool.  This will just bring in any future date values and pivot them out automatically for you.  -Jay