Re^2: How to check last used date.

Thanks for the suggestions. I have the data structure that needs 2 dimentional Hash of arrays. I will need to find out the Specific ID and their respective Netowrk IDs and which was not used and the used one Network ID to be checked with Last used among the usages. Please check my latest data structure . How i can create a 2 dimentional Hash of arrays and extract the unique data? Can you please consider @array1 as the Key @array 3 is the 2nd and @arra3 is the respective values? Please check ID 500000008

@array1            @array3             @array2    @arra3
900000001    900000001    Network1    Login
900000002    900000002    Network1    2019-11-07T20:31:10.000Z
900000002    900000002    Network1    2021-02-19T13:47:25.000Z
900000002    900000002    Network1    2021-03-10T13:58:50.000Z
900000003    NOT Registered    No Network1    NOT Registered
900000004    900000004    Network1    Login
900000005    900000005    Network1    Login
900000006    900000006    Network1    Login2
900000007    900000007    Network1    2021-03-10T17:11:24.000Z
900000007    900000007    Network1    2021-02-18T08:34:58.000Z
900000007    900000007    Network1    2021-01-25T17:19:44.000Z
500000008    500000008    Network1    2021-03-10T17:11:24.000Z
500000008    500000008    Network2    Not Used
500000008    500000008    Network1    2021-03-11T17:12:42.000Z
500000008    500000008    Network3    Not Used
400000008    400000008    Network1    2021-01-25T17:19:36.000Z
[download]

Comment on Re^2: How to check last used date. Download Code

Replies are listed 'Best First'.
Re^3: How to check last used date. by davido (Cardinal) on Mar 13, 2021 at 21:03 UTC
So now you have three problems that you seem to be asking about: How to sort by date, or find the maximum date. How to extract the user ID and date from tabular data. How to insert data into a datastructure Which part of the problem are you able to solve yourself, so that we can help with the parts you can't solve? Show us the minimal amount of code you can write to get started on this. Sample input, sample output, code that compiles, etc. Dave	[reply]

Replies are listed 'Best First'.

Re^3: How to check last used date.
by davido (Cardinal) on Mar 13, 2021 at 21:03 UTC

So now you have three problems that you seem to be asking about:

How to sort by date, or find the maximum date.
How to extract the user ID and date from tabular data.
How to insert data into a datastructure

Which part of the problem are you able to solve yourself, so that we can help with the parts you can't solve? Show us the minimal amount of code you can write to get started on this. Sample input, sample output, code that compiles, etc.

Dave

[reply]