Randomly selecting date from excel

[Raj008]

Hi Everyone,

I need to randomly select the data from a date column

for eg., today is 1/6/2021, i need the values belonging to 1/8/2021 from the excel for ABC and DEF

Date   1/4/2021   1/5/2021   1/6/2021

ABC    0.1%         0.11%       0.2%

DEF    1.1%          1.22%     1.41%

if it is tmrw, it should pick from 1/7/2021; the values in the excel gets changed everyday (Monday thru Friday)

Thanks....

[Qiu]

@Raj008 

By Random, you mean any date that is after "Today"?

[Qiu]

@Raj008 

Something like this?

[Raj008]

Hi Qiu,

The excel is getting updated every business day, so the workflow should pick up the next column when the date is updated. Today is 2/14/2021 and when the workflow is run it should pick up 2/14/2021 column for values. When it runs tmrw, 2/15/2021, the excel gets updated with 2/15/2021 and the workflow should pick the values from 2/15/20201 column.

Thanks...

[Raj008]

Hi Qiu,

I am sorry, it is not random, it should pick dynamically....

Thanks

[ijkiv]

 Hi, 

If I understand correctly, you wish to get data from the correct column, which will be determined by a date (i.e. today's date).

What you can do is to load the data, and then use Dynamic Select tool. This tool allows you to specify a condition that will determine what column to read out. See the workbook attached. 

Hope this helps. 

[Qiu · Accepted solution]

@Raj008 

Then it will be easier actually.😁