I have a report that has multiple columns of data based on period. How can I make this dynamic so that only the current and prior period is selected? For this example, column V is the current period and column T is the prior period. How would I only display those columns (along with Columns A-G) Thanks EAC Comparison TEST.xlsx

dynamically select data columns

I have a report that has multiple columns of data based on period. How can I make this dynamic so that only the current and prior period is selected?

Column select.jpg

For this example, column V is the current period and column T is the prior period.

How would I only display those columns (along with Columns A-G)

Thanks

EAC Comparison TEST.xlsx

Transformation

Accepted answers

binu_acs

@tiverson I am able to run the workflow with your test file

Percent_diff_291123.yxzp

Percent_diff_291123.yxmd

All comments

cjaneczko

Simple way to do this would be to use a Field Info tool and then filter that grabs the most recent two dates. You'll need to add a record ID field as well. Then Crosstab the Field Info based on Record ID for the header and Name as the data. Use a Dynamic Rename tool and make the Name as the new Header. Then Union back to your original Dataset and only union only on the fields from your Crosstabbed data set.

binu_acs

@tiverson you can use the dynamic select tool for this, the same logic you can see in your previous post

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Calculate-Difference-between-values-current-prior-and-diff/m-p/1213639#M301480

tiverson

@binu_acs , I tried the other workflow to my data and am not getting any of the "period" data. The example used in my original question had the periods as data type "Double", where this example has V string for the Period values. I want to try and change the data type to Double dynamically since the number of columns will change. (I even tested by manually changing all of the "EAC" columns to double and still was unable to get any output)