Dynamic column name with dynamic select

Question

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

image-1763716450713.jpg

jrlindem · Answer

@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

Saranyaram · Answer

@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

Screenshot 2025-11-26 091402.png

jrlindem · Answer

@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

jrlindem_example.yxmd