Changing rows

Help
, ,
1

I have a report that I do every day. I receive this report every morning from somewhere, but I do not receive the entire report, but only a certain part. However, there is a situation that changes every day in the part I buy. For example, if the line I want to take one day is 67, the next day it can be 69. For reasons not caused by me. How can I copy this correctly to other excel file? I don’t want to do it manually every day by doing read rows. I would really appreciate if you can help.

2

Hi @Erdem_Hamza
Welcome to the UiPath Community!

This row that you’re looking for, what are the telling features about this line? Is there a certain column containing a certain value which you look out for?
Can you please share an example of what type of data may be in rows 67 and 69, going by your example?

3

Thank you

Without manually entering the row order. How can I get the robot to read automatically?

Is it possible to find line spacing by searching a word in the table? Because the lines in a certain range are combined.

4

@Erdem_Hamza

Welcome to community

It would be great if you provide some example screenshots of input and expected output

Hope this will help to understand your usecase

Thanks

5

I cannot share screenshots because I am a new member. Sorry.

This is the line differences I want to mention. If you notice, one range is 67-83, while the other range is 74-92. I gave the ranges I mentioned as an example. Because it can change every day.

I also want the robot to detect these intervals automatically. The cells between the ranges I mentioned are combined.

6

Can you give a sample of what data are you looking for?
Is there a certain text you’re looking for in this range? It’s okay if you’re unable to share screenshots yet, just mention a dummy data in text format.

What is the column value at say column A of the start of the range?

8

As you can see in the table, I want to copy the numbers in the place where it says “Hafif Ticari” and in other columns.

Ekran Alıntısı321
Ekran Alıntısı3211566×472 30 KB
Ekran Alıntısı123
Ekran Alıntısı1231581×418 28.7 KB

9

@Erdem_Hamza Do you want the Highlighted part as the Output ?

45407c3f756bd4bed6a6a9a6f1e97a93046ed8a7
45407c3f756bd4bed6a6a9a6f1e97a93046ed8a71566×472 30.5 KB

Also, If possible can you send the excel file as well. There might be a pattern to use around “Total” and the keyword “HAFIF TICARI” to get the required values from the other columns, but I would say it would all depend on the format of the excel file and How the required values are being positioned in the excel.

I do not think we can use this as the pattern as it has a set of different ranges. So this would not be much helpful.

10

@supermanPunch
Hello, thank you for your help. I had to delete some places in the Excel file because it contains confidential information. The part I want to use in the robot will only be the part indicated in yellow, and your model name and total approach written there made sense. I think it will be more effective if we go from the model names.RPA excel.xlsx (15.5 KB)

11

@Erdem_Hamza Can you check this workflow :
ExtractTableFromTable.zip (17.3 KB)

Also make sure to check it with different inputs. Revert back if it is not according to your requirements.

12

@supermanPunch
Thank you very much my brother worked. I will also have other questions for you. Can I write them as a message?
Thank you so much.

13

@Erdem_Hamza Yes. You can ask the questions. You can put me a private message but I would suggest you to create a new post so that you would get different answers and a different point of view to your Questions. Also I’ll be busy and will not be able to reply immediately :sweat_smile:

1 Like
14

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