cancel
Showing results for 
Search instead for 
Did you mean: 

Efficient Data Storage Method for Monthly Codes

sandeshtope
Level 4

I'm seeking advice on structuring a data storage system for the last 6 months' worth of codes. Each code follows a consistent pattern: GOV followed by a number representing the month (e.g., GOV3, GOV2, GOV1, GOV12, GOV11, GOV10). What would be the most efficient method to organize and manage these codes as separate data items while ensuring easy access and retrieval?

1 BEST ANSWER

Best Answers

Daniel_Sanhueza
Level 7

Hello Sandy!

I would have 6 Data Items named according to the month to be searched for;

  • [M-1]= Month -1
  • [M-2]= Month -2
  • [M-3]= Month -3 

And so on... at the beggining of the process flow I'll put a Multicalc Stage that send the values to each Data Item with a simple function;

 

"GOV"&ToNumber(FormatDate(AddMonths(Today(); -1),"MM"))

 

1.png

2.png

And ensure that checkbok "hide from other pages in the process" is unchecked to make them Global so you can use those Data Items anywhere on the process flow.

3.png

Hope this helps

 

 

Daniel Sanhueza
RPA Professional Developer
Deloitte

View answer in original post

2 REPLIES 2

Daniel_Sanhueza
Level 7

Hello Sandy!

I would have 6 Data Items named according to the month to be searched for;

  • [M-1]= Month -1
  • [M-2]= Month -2
  • [M-3]= Month -3 

And so on... at the beggining of the process flow I'll put a Multicalc Stage that send the values to each Data Item with a simple function;

 

"GOV"&ToNumber(FormatDate(AddMonths(Today(); -1),"MM"))

 

1.png

2.png

And ensure that checkbok "hide from other pages in the process" is unchecked to make them Global so you can use those Data Items anywhere on the process flow.

3.png

Hope this helps

 

 

Daniel Sanhueza
RPA Professional Developer
Deloitte

LeonardoSQueiroz
Level 10

Hello,

I have already been through a project with a similar requirement, because in our scenario we needed to consult both the complete value and just the code, what we did was create an auxiliary column that contained only the code, and a second column with the value suffix, according to the requirement we could have other suffixes, we abstracted the logic through a view in the Database (I don't know if this is your case), and we transposed the data to the collection later for reasons of performance and execution duration (high volume);

 

Regards

Leonardo Soares RPA Developer América/Brazil