Write a value to junction point of row and column

Help StudioX
1

hi there! here is the situation.

in first sheet i have row numbers, column numbers and values from invoices that are dynamic. im reading pdf files an writing them to excel
image

in second sheet i have rows and column numbers which are static.
A spreadsheet with red headers containing numerical codes and blank cells below, alongside a numbered list from 1 to 26 on the left. (Captioned by AI)e

i need to take row and column numbers from first sheet and search them in second sheet when i find i want to write a value in junction point of them

so i have two question, how ican i search specific number from another sheet, and how can i write a specific number to junction point of them?

i hope i have explained clearly, thanks for your help

2

Hi, @Affan_Basar

It is a confused. Can you give more detail. Because I started to project.

Is it like that;

The image is a spreadsheet showing a process of matching values across columns and rows, with an illustration of selected values and an arrow indicating the transfer of a value (78016) to a specified cell. (Captioned by AI)
The image is a spreadsheet showing a process of matching values across columns and rows, with an illustration of selected values and an arrow indicating the transfer of a value (78016) to a specified cell. (Captioned by AI)867×357 7.9 KB

3

Hi @Affan_Basar

Try the xml file attached
Sequence.xaml (9.1 KB)

Thank You

4

Thanks a lot, so in the excel file you will see sheet1 there are red numbers (işyeri numarası, belge kodu, kanun kodu) i need to search “işyeri numarası” in “LISTE” column “C” and search “belge kodu, kanun kodu” in 2. row,

for example in column “C” i need to find “112” and 2. row i need to find “1 - 5510” its actually column “G” so the junction point is “G, 64” i need to write this cell “Toplam Prim” which is 1.271.216,82
,.xlsx (21.4 KB)

5

we merge column a and column b then we search, i forget to mention this sorry for that.

so its like this;

The image depicts an Excel spreadsheet with various cells highlighted, showing a process of retrieving a value (78016) from a specific row and column based on indices and relocating it to another cell. (Captioned by AI)
The image depicts an Excel spreadsheet with various cells highlighted, showing a process of retrieving a value (78016) from a specific row and column based on indices and relocating it to another cell. (Captioned by AI)867×357 8.03 KB

7

and we write “value to write” which is 300 for this one to that cell

8

Türkçe biliyor musunuz? Mümkünse türkçe yazın :slight_smile:

9

selamlar :slight_smile:
a kolonu ve b kolonundaki sayıları birleştirerek arıyoruz. şekildeki örnek için 1 ve 78016 yı birleştirip 1 - 78016 olan kolonu buluyoruz. burası cepte.
daha sonra ilk kolon "row A"da yer alan değerleri sizin de şekilde gösterdiğiniz gibi “G” sütununda arıyoruz. şekilde 2. burası da cepte
son olarak 2 ile 1 - 78016’nın kesiştiği yeri buluyoruz.siyah çizgi ile gösterdiğim yer. kesişime “value to write” kolonunda yazan ve 2, 1, 78016 ile aynı satırda yer alan 300 değerini giriyoruz.

excelde yapmak istesek aslında tüm süreci index match ile biraz uğraşarak yapabiliriz. ancak burada durum ileriki safhalarda değiştiği için bu kısmı rpa ile yapmaya çalışıyorum.

umarım açıklayabilmişimdir :slight_smile: yardımınız için teşekkürler

10

@Affan_Basar Selamlar :slight_smile:

Tamam şimdi oldu. Hafta sonu bu algoritmayı çıkartırım. Güzel ve farklı bir senaryo.
Yapınca buradan paylaşırım.

Görüşmek üzere :slight_smile:

11

Tamamdır, teşekkür ediyorum, görüşmek üzere…

12

Merhaba , @Affan_Basar

Çözdüm. :slight_smile:
Index mantığını uipatte anlamaya çalış. Güzel bir örnek oldu. Anlaşılmayan veya karışık bir bölüm varsa açıklamaya çalışırım. Paylaştığım data excelindeki değerlerle deneme yaparsın. Daha sonra kendi sürecine entegere edersin.

Main.xaml (52.6 KB)
Data.xlsx (10.1 KB)

The image shows an Excel spreadsheet where specific values are written in designated cells based on coordinates from columns labeled with reference data, with a section titled "RESULT" in red text indicating the output area. (Captioned by AI)
The image shows an Excel spreadsheet where specific values are written in designated cells based on coordinates from columns labeled with reference data, with a section titled "RESULT" in red text indicating the output area. (Captioned by AI)805×514 18.3 KB

The image depicts a UiPath workflow that reads data from two Excel sheets and performs a "For Each" loop to add column names from the "Sheet2_Static_DT" data table to a collection list. (Captioned by AI)
The image depicts a UiPath workflow that reads data from two Excel sheets and performs a "For Each" loop to add column names from the "Sheet2_Static_DT" data table to a collection list. (Captioned by AI)778×648 41.4 KB

The image depicts a nested workflow process in an automation tool, where it iterates through rows in two data tables to compare values and log messages based on the comparison. (Captioned by AI)
The image depicts a nested workflow process in an automation tool, where it iterates through rows in two data tables to compare values and log messages based on the comparison. (Captioned by AI)677×804 32.4 KB

The image displays a process flow in a UiPath automation workflow, involving reading Excel data, assigning values, logging messages, and iterating through a list of items. (Captioned by AI)
The image displays a process flow in a UiPath automation workflow, involving reading Excel data, assigning values, logging messages, and iterating through a list of items. (Captioned by AI)613×833 31.1 KB

A conditional workflow in UiPath processes a column index and logs its corresponding letter before writing data to an Excel workbook. (Captioned by AI)
A conditional workflow in UiPath processes a column index and logs its corresponding letter before writing data to an Excel workbook. (Captioned by AI)511×671 24.5 KB

13

süper :slight_smile:
eline sağlık, en kısa sürede deneyip haber veriyorum.

14

Merhaba @Affan_Basar kontrol edebildin mi acaba

15

selamlar, fırsat buldukça bakıp içinden çıkmaya çalışıyorum :slight_smile: durum şöyle ki dosyayı doğrudan çalıştıramadım. versiyon farkı muhtemelen bazı fonksiyonlar hatalı geldi onları yeniden tanımladım ancak hata almaya devam etti. şimdi örnek alıp kendim ayrı bir sequnceda yazmaya çalışıyorum. bazı yerlerde soru işaretlerim var bitince toplu olarak sorayım

16

Anlaştık kolay gelsin.

17

son iki for each’in disable edilme sebebi neydi? bunlar olmadan da doğru şekilde çalışıyor mu?

18

This may work better?
Input data:
image

Process:

image
image1249×2234 148 KB

Output:
image

Edit: Removed unnecessary steps from the process.

19

@Affan_Basar Evet evet deneme yaparken kalmıştır.

1 Like
20

@Affan_Basar , also made an option2 for you.

Result:

image
image489×655 7.18 KB

Process:

image
image1249×3079 210 KB

21

Karıştıysa toplantı yapabilriz.