Extract data to specific datatable

Help Studio
, , , , ,
1

May I ask how can I extract data from specific column from ‘seed’ to ‘GU Con’.
For example, how can I collect first GU # data:
‘250.65’ from cell V2:V5 from ‘seed’ to cell E2 from ‘GU Con’;
‘250.26’ from cell Y2:Y5 from ‘seed’ to cell F2 from 'GU Con;
‘251.40’ from cell W2:W5 from ‘seed’ to cell E3 from 'GU Con;
‘250.35’ from cell X2:X5 from ‘seed’ to cell E4 from ‘GU Con’, etc based on each GU#.

Then, how I can extract second GU#,
‘250.58’ from cell V6:V9 from ‘seed’ to cell E8 from 'GU Con, etc?

The template is follow:

image
image1920×1009 124 KB

The file:
SEED to GU.xlsx (115.7 KB)

2

Use Read Range to get the cell ranges you want.

You really should do the free training on academy.uipath.com - it’ll teach you things like how to work with ranges.

3

Hi,

How about the following sample? (please check result.xlsx)

image
image668×1966 47.3 KB

Sample
Sample20240222-1a.zip (107.9 KB)

Regards,

1 Like
4

Thank you so much, but what if GU number is greater than 6, because I need to extract all data from seed, which is more than 6 GU number, how I extract data based on all GU number?

5

image
image1920×1009 148 KB

In this example, I need to extract data for all GU number ie from GU-23-0037 to GU-23-0049, how can I edit the workflow? Thank you so much.

6

Can you elaborate about your concern?
I think the above sample doesn’t depend number of rows of GU#.

Regards,

7

The sample can help me to solve how I can extract specific data to specific row, but I need to do more is about the get all GU number from ‘seed’ to ‘GU Con’.

8

image
image1920×1009 131 KB

The GU-con need to include all GU number data from seed, Thank you so much !!

9

In the above sample, dict.Keys return all the GU number in seed as the following.

image

10

Do i need to create now assign activity ?

11

May I ask what i need to add if I dont need the message box appear? Thank you so much

12

Can you clarify input and expected output?
Do you want to append GU number except existing GU number in “GU Con”?

13

Yes

image
image1416×752 172 KB

The append data from all GU number that exist in ‘seed’ (column D) to the ‘GU con’ is my expected output.

14

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