How to have collection for deposit and total amount tie to tat deposit

Help Studio
1

Hi there,

The image shows a spreadsheet containing financial information such as deposits, banking types, accounts, cost centers, and amounts. (Captioned by AI)
The image shows a spreadsheet containing financial information such as deposits, banking types, accounts, cost centers, and amounts. (Captioned by AI)1045Ă—1230 85.4 KB

Need to store all the 3 deposit and total amount where i will the total amount to recon later. So i need help how to store and use them?

Forum Engagement Daily Reports
2

@mark_rajkumar1

use a dictionary with key as deposit first column and value as the total amount

cheers

3

@Anil_G can i get the work flow

4

@mark_rajkumar1

only an assign is needed with values you need

The image shows a programming interface where a dictionary variable named 'dict' is being assigned with a key-value pair, with the variable details listed below it. (Captioned by AI)
The image shows a programming interface where a dictionary variable named 'dict' is being assigned with a key-value pair, with the variable details listed below it. (Captioned by AI)1142Ă—476 12.6 KB

cheers

5

@Anil_G for deposit i can put an assign but for the amount which has 4 rows how do i get total and assign

6

@mark_rajkumar1

basically you want the data to be read as datatable and then save as well ..as the question was not clear as it want asked for a way to save

okay so if each data could be read as separate datable then dt.AsEnumerable.Sum(function(x) cdbl(x(“column to be totalled”).Tostring)).Tostring this gives total as string

if all the rows are read together into single datatable then you might need to first loop through each row and find out the total like by checking first column is empty get the total till there and then change the deposit account number and repeat the same in loop

cheers

7

@mark_rajkumar1

Can you give more details about your scenario.

What is Input

What is output you are expecting

8

@yedukondaluaregala @Anil_G i am trying to store all the deposit and its total amount e.g. 112h, 300 in a datatable where i will use it recon in a browser.

9

Hi @mark_rajkumar1

Can you try this

The image depicts a diagram of a UiPath automation workflow that processes Excel data by reading, filtering, looping through rows, and assigning values. (Captioned by AI)
The image depicts a diagram of a UiPath automation workflow that processes Excel data by reading, filtering, looping through rows, and assigning values. (Captioned by AI)1184Ă—901 31.1 KB

Sequence9.xaml (14.6 KB)

Output:

The image depicts a log showing the execution of a file named Sequence9, capturing details of RPA Challenge activities such as deposits and their totals, highlighted for emphasis. (Captioned by AI)
The image depicts a log showing the execution of a file named Sequence9, capturing details of RPA Challenge activities such as deposits and their totals, highlighted for emphasis. (Captioned by AI)677Ă—250 8.82 KB

Regards,

10

Hi @lrtetala ur solution worked. I want to add on one more item which will be a date column which will in column b. For each deposit there would be a date. How do i group deposit date and amount using same method above?

11

Hi @mark_rajkumar1

Can you share the input, how it looks?

Regards,

12

@lrtetala

A spreadsheet listing deposits, banking types, dates, accounts, cost centers, and corresponding amounts in separate columns. (Captioned by AI)
A spreadsheet listing deposits, banking types, dates, accounts, cost centers, and corresponding amounts in separate columns. (Captioned by AI)1027Ă—541 76.3 KB

1 Like
13

@mark_rajkumar1

Can you try this

This image displays a workflow diagram that processes an Excel file by reading data, filtering it, and extracting specific field values with logging steps for messages. (Captioned by AI)
This image displays a workflow diagram that processes an Excel file by reading data, filtering it, and extracting specific field values with logging steps for messages. (Captioned by AI)1178Ă—1360 72.3 KB

Sequence9.xaml (20.0 KB)

Output:

The image depicts a log detailing the execution of an RPA challenge, including the date, amount, deposits, and runtime for the process sequence. (Captioned by AI)
The image depicts a log detailing the execution of an RPA challenge, including the date, amount, deposits, and runtime for the process sequence. (Captioned by AI)1520Ă—387 23.5 KB

Regards,

1 Like
14

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.