Selection Tool Automation

Hey,

I have a file which contains date columns of both historical and forecast. My objective is to automate the process of selecting only the forecast (future) columns. For example: If I am running the workflow in Nov'17, the tool should select all the columns after and including Nov'17. Right now I am selecting the columns manually. Is there anything which can automate this?

Thanks!

Capture.PNG

Developer Tools

Tips and Tricks

Date Time

Preparation

Accepted answers

jdunkerley79

Can you drop a list of sample column names then I can tune for you.

This expression should only dynamically filter dates:

!REGEX_MATCH([Name],"\d{4}-\d{2}-\d{2}")
OR
([Name]>=Left(DateTimeTrim(DateTimeToday(), "Month"),10)
AND
[Name]<Left(DateTimeAdd(DateTimeTrim(DateTimeToday(), "Month"), 12, "Month"),10))

Hopefully should work for you.

All comments

JoshKushner

You can do this with the Transpose Tool.

After your data, add record ID's, transpose with recordID as a key field, filter all rows with name before Nov17 (orwhatever you want), cross tab back grouping by recordID

jdunkerley79

You could use a Dynamic Select with a formula:

[Name]>DateTimeToday()

Sample attached

Dynamic Select.yxmd

ayadav8

@jdunkerley79 The idea is great. However, I want to select only the coming one year months. Can I do that? My file has coming 24 months fields. How can I select only the next 12 months. i.e Nov'17 - Oct'18

Note: The present month is to be included in the selection.

Thanks!!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703