How to merge 2 datasets by multy criteria?

(1) Share

Report

Posted on by Andrey86

Dears,

Please help to solve that case in Power Automate desktop:

I have 2 datasets with prefilled data, need to lookup in table2 by multy statements and copy data from table2[Column4] to table1[СуммаGL]

Ur help will greatfull for me

Andrey

Categories:

Power Automate Desktop

All responses (12)

Answers (0)

Sort by

MichaelAnnis 5,727 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

I’d do it in Excel and use Sumifs. I’m sure you could do something similar with sql, but SUMIFS in excel would definitely work.

Use write to Excel to save them to one file with two tabs and have GPT write you a macro to fill in the column using sumifs.

then, PAD is just used to:

get tables

write tables to Excel

Run Macro

Read From Excel (now the new table is in PAD and you can do with it what you wish.)

if the tables are already in Excel and you just need to populate the column SUMIFS will do.

good luck!
Andrey86 14 on at

Like
a
(1)

Report
Copy link

Link copied!

Thank you. but no. I mut use only PAD as extractor, w/o any additional
Sayan 818 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

Hey @Andrey86

Just need a confirmation that the Tables are present in a SQL server or Excel.
can your please share the sources of your data?

------------------------------------------------------------------------------------------------------------------------------
Thanks,
Sayan Patra | RPA Developer

Andrey86

14 on at

Like (1)

Report

Copy link

Link copied!

Its easy to understand if I sent an example from PAD

Variables.CreateNewDatatable InputTable: { ^['БЕ', 'Кассовая книга', 'Основной счет', 'Начальное сальдо', 'Сумма прихода наличных', 'Сумма поступивших чеков', 'Сумма выдачи наличных', 'Остаток', 'из них наличные', 'СуммаGl', 'Разница'], [$'''KZ10''', $'''KZT1''', 240001000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ10''', $'''KZT2''', 240002000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ10''', $'''KZT3''', 240003000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ10''', $'''KZT4''', 240004000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ10''', $'''KZT5''', 240005000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ10''', $'''KZT6''', 240006000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ10''', $'''KZT7''', 240007000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ10''', $'''KZT8''', 240008000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ10''', $'''KZT9''', 240009000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ10''', $'''KZ10''', 240010000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ10''', $'''KZ11''', 240011000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ10''', $'''KZ12''', 240012000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ10''', $'''KZ13''', 240013000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ10''', $'''KZ14''', 240014000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ10''', $'''KZ15''', 240015000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ10''', $'''KZ16''', 240016000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ10''', $'''KZ17''', 240017000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ10''', $'''KZ18''', 240018000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ10''', $'''KZ19''', 240019000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ10''', $'''KZ20''', 240020000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ17''', $'''KZT1''', 240001000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ17''', $'''KZT2''', 240002000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ17''', $'''KZT3''', 240003000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ17''', $'''KZT4''', 240004000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ17''', $'''KZT5''', 240005000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ17''', $'''KZT6''', 240006000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ17''', $'''KZT7''', 240007000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ17''', $'''KZT8''', 240008000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ17''', $'''KZT9''', 240009000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ17''', $'''KZ10''', 240010000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ17''', $'''KZ11''', 240011000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ17''', $'''KZ12''', 240012000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ17''', $'''KZ13''', 240013000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ17''', $'''KZ14''', 240014000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ17''', $'''KZ15''', 240015000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ17''', $'''KZ16''', 240016000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ17''', $'''KZ17''', 240017000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ17''', $'''KZ18''', 240018000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ17''', $'''KZ19''', 240019000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ17''', $'''KZ20''', 240020000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ17''', $'''KZ21''', 240021000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ17''', $'''KZ22''', 240022000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ20''', $'''KZT1''', 240001000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ20''', $'''KZT2''', 240002000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ20''', $'''KZT3''', 240003000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ20''', $'''KZT4''', 240004000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ20''', $'''KZT5''', 240005000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ20''', $'''KZT6''', 240006000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ20''', $'''KZT7''', 240007000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ20''', $'''KZT8''', 240008000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ20''', $'''KZT9''', 240009000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ20''', $'''KZ10''', 240010000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ20''', $'''KZ11''', 240011000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ20''', $'''KZ12''', 240012000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ20''', $'''KZ13''', 240013000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ20''', $'''KZ14''', 240014000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ20''', $'''KZ15''', 240015000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ20''', $'''KZ16''', 240016000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ20''', $'''KZ17''', 240017000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ20''', $'''KZ18''', 240018000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''] } DataTable=> DataTable
Clipboard.GetText Text=> ClipboardText
Text.SplitText.Split Text: ClipboardText StandardDelimiter: Text.StandardDelimiter.NewLine DelimiterTimes: 1 Result=> TextList
Variables.GenerateDataTableFromCSV.ReadCustomSeparator CSVText: TextList TrimFields: True FirstLineContainsColumnNames: False ReadFieldsAsText: False CustomColumnsSeparator: $'''|''' CSVTable=> CSVTable
Variables.DeleteColumnFromDataTable.DeleteColumnWithIndex DataTable: CSVTable ColumnIndex: 0
Variables.DeleteColumnFromDataTable.DeleteColumnWithIndex DataTable: CSVTable ColumnIndex: 3
Variables.FindOrReplaceInDataTable.ReplaceItemInDataTableByColumnIndex DataTable: CSVTable AllMatches: True ValueToFind: $'''* ''' MatchCase: False MatchEntireCellContents: False TextToReplaceWith: $'''%''%''' ColumnNameOrIndex: 0
Variables.FindOrReplaceInDataTable.ReplaceItemInDataTableByColumnIndex DataTable: CSVTable AllMatches: True ValueToFind: $'''*KZ10''' MatchCase: False MatchEntireCellContents: False TextToReplaceWith: $'''%''%''' ColumnNameOrIndex: 0
Variables.FindOrReplaceInDataTable.ReplaceItemInDataTableByColumnIndex DataTable: CSVTable AllMatches: True ValueToFind: $'''*KZ17''' MatchCase: False MatchEntireCellContents: False TextToReplaceWith: $'''%''%''' ColumnNameOrIndex: 0
Variables.FindOrReplaceInDataTable.ReplaceItemInDataTableByColumnIndex DataTable: CSVTable AllMatches: True ValueToFind: $'''*KZ20''' MatchCase: False MatchEntireCellContents: False TextToReplaceWith: $'''%''%''' ColumnNameOrIndex: 0
Variables.FindOrReplaceInDataTable.ReplaceItemInDataTableByColumnIndex DataTable: CSVTable AllMatches: True ValueToFind: $'''***''' MatchCase: False MatchEntireCellContents: False TextToReplaceWith: $'''%''%''' ColumnNameOrIndex: 0
Variables.FindOrReplaceInDataTable.ReplaceItemInDataTableByColumnIndex DataTable: CSVTable AllMatches: True ValueToFind: $'''БЕ''' MatchCase: False MatchEntireCellContents: False TextToReplaceWith: $'''%''%''' ColumnNameOrIndex: 0
SET Iter TO 0
LOOP FOREACH CurrentItem2 IN CSVTable
 IF IsEmpty(CurrentItem2[0]) THEN
 Variables.DeleteRowFromDataTable DataTable: CSVTable RowIndex: Iter
 ELSE
 Variables.IncreaseVariable Value: Iter IncrementValue: 1
 END
END

Entering data (just copy below to clipboard):

TOО "БЦК" Отд. позиции Гл. книги Дата 15.07.2024
Бухтарма Страни 1
-----------------------------------------
| БЕ |ГлавКнига | Сумма в ВВ|
-----------------------------------------
|* KZ10|240001000 | 8 378 509,45 |
|* KZ10|240002000 | 135 879,27 |
|* KZ10|240003000 | 13 726,20 |
|* KZ10|240004000 | 96 206,28 |
|* KZ10|240005000 | 0,00 |
|* KZ10|240007000 | 0,00 |
|* KZ10|240009000 | 0,00 |
|* KZ10|240010000 | 0,00 |
|* KZ10|240012000 | 502 960,27 |
|* KZ10|240013000 | 0,00 |
|* KZ10|240014000 | 0,00 |
|* KZ10|240016000 | 0,00 |
|* KZ10|240017000 | 199,00 |
|* KZ10|240018000 | 0,00 |
|* KZ10|240019000 | 0,00 |
|* KZ10|240020000 | 0,00 |
-----------------------------------------
|** KZ10| | 9 127 480,47 |
-----------------------------------------
|* KZ17|240001000 | 0,00 |
|* KZ17|240002000 | 325,00 |
|* KZ17|240003000 | 45 070,00 |
|* KZ17|240004000 | 560 640,00 |
|* KZ17|240005000 | 0,00 |
|* KZ17|240006000 | 0,00 |
|* KZ17|240007000 | 9 161,50 |
|* KZ17|240008000 | 950,00 |
|* KZ17|240009000 | 0,00 |
|* KZ17|240010000 | 209 500,00 |
|* KZ17|240011000 | 258 805,00 |
|* KZ17|240012000 | 0,00 |
|* KZ17|240013000 | 26 508,00 |
|* KZ17|240014000 | 0,00 |
|* KZ17|240015000 | 45 040,10 |
|* KZ17|240016000 | 0,00 |
|* KZ17|240017000 | 0,00 |
|* KZ17|240018000 | 0,00 |
|* KZ17|240019000 | 0,00 |
|* KZ17|240020000 | 1 482 675,00 |
|* KZ17|240021000 | 296 014,00 |
|* KZ17|240022000 | 1 372 655,00 |
-----------------------------------------
|** KZ17| | 4 307 343,60 |
-----------------------------------------
|* KZ20|240001000 | 0,00 |
|* KZ20|240003000 | 0,00 |
|* KZ20|240004000 | 135 879,70 |
|* KZ20|240005000 | 3 335,38 |
|* KZ20|240006000 | 64 900,19 |
|* KZ20|240007000 | 0,00 |
|* KZ20|240008000 | 109 776,00 |
|* KZ20|240009000 | 51 545,00 |
|* KZ20|240010000 | 0,00 |
|* KZ20|240011000 | 0,00 |
|* KZ20|240012000 | 0,00 |
|* KZ20|240013000 | 0,00 |
|* KZ20|240014000 | 979,20 |
|* KZ20|240015000 | 0,00 |
|* KZ20|240016000 | 51 375,00 |
|* KZ20|240017000 | 0,00 |
|* KZ20|240018000 | 0,00 |
-----------------------------------------
|** KZ20| | 417 790,47 |
-----------------------------------------
|*** | | 13 852 614,54 |
-----------------------------------------

Andrey86

14 on at

Like (1)

Report

Copy link

Link copied!

Hi, it's easy to share a flow from PAD and source:

PAD script is

Variables.CreateNewDatatable InputTable: { ^['БЕ', 'Кассовая книга', 'Основной счет', 'Начальное сальдо', 'Сумма прихода наличных', 'Сумма поступивших чеков', 'Сумма выдачи наличных', 'Остаток', 'из них наличные', 'СуммаGl', 'Разница'], [$'''KZ10''', $'''KZT1''', 240001000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ10''', $'''KZT2''', 240002000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ10''', $'''KZT3''', 240003000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ10''', $'''KZT4''', 240004000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ10''', $'''KZT5''', 240005000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ10''', $'''KZT6''', 240006000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ10''', $'''KZT7''', 240007000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ10''', $'''KZT8''', 240008000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ10''', $'''KZT9''', 240009000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ10''', $'''KZ10''', 240010000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ10''', $'''KZ11''', 240011000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ10''', $'''KZ12''', 240012000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ10''', $'''KZ13''', 240013000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ10''', $'''KZ14''', 240014000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ10''', $'''KZ15''', 240015000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ10''', $'''KZ16''', 240016000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ10''', $'''KZ17''', 240017000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ10''', $'''KZ18''', 240018000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ10''', $'''KZ19''', 240019000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ10''', $'''KZ20''', 240020000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ17''', $'''KZT1''', 240001000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ17''', $'''KZT2''', 240002000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ17''', $'''KZT3''', 240003000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ17''', $'''KZT4''', 240004000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ17''', $'''KZT5''', 240005000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ17''', $'''KZT6''', 240006000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ17''', $'''KZT7''', 240007000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ17''', $'''KZT8''', 240008000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ17''', $'''KZT9''', 240009000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ17''', $'''KZ10''', 240010000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ17''', $'''KZ11''', 240011000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ17''', $'''KZ12''', 240012000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ17''', $'''KZ13''', 240013000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ17''', $'''KZ14''', 240014000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ17''', $'''KZ15''', 240015000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ17''', $'''KZ16''', 240016000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ17''', $'''KZ17''', 240017000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ17''', $'''KZ18''', 240018000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ17''', $'''KZ19''', 240019000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ17''', $'''KZ20''', 240020000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ17''', $'''KZ21''', 240021000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ17''', $'''KZ22''', 240022000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ20''', $'''KZT1''', 240001000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ20''', $'''KZT2''', 240002000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ20''', $'''KZT3''', 240003000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ20''', $'''KZT4''', 240004000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ20''', $'''KZT5''', 240005000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ20''', $'''KZT6''', 240006000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ20''', $'''KZT7''', 240007000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ20''', $'''KZT8''', 240008000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ20''', $'''KZT9''', 240009000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ20''', $'''KZ10''', 240010000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ20''', $'''KZ11''', 240011000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ20''', $'''KZ12''', 240012000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ20''', $'''KZ13''', 240013000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ20''', $'''KZ14''', 240014000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ20''', $'''KZ15''', 240015000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ20''', $'''KZ16''', 240016000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ20''', $'''KZ17''', 240017000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ20''', $'''KZ18''', 240018000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''] } DataTable=> DataTable
Clipboard.GetText Text=> ClipboardText
Text.SplitText.Split Text: ClipboardText StandardDelimiter: Text.StandardDelimiter.NewLine DelimiterTimes: 1 Result=> TextList
Variables.GenerateDataTableFromCSV.ReadCustomSeparator CSVText: TextList TrimFields: True FirstLineContainsColumnNames: False ReadFieldsAsText: False CustomColumnsSeparator: $'''|''' CSVTable=> CSVTable
Variables.DeleteColumnFromDataTable.DeleteColumnWithIndex DataTable: CSVTable ColumnIndex: 0
Variables.DeleteColumnFromDataTable.DeleteColumnWithIndex DataTable: CSVTable ColumnIndex: 3
Variables.FindOrReplaceInDataTable.ReplaceItemInDataTableByColumnIndex DataTable: CSVTable AllMatches: True ValueToFind: $'''* ''' MatchCase: False MatchEntireCellContents: False TextToReplaceWith: $'''%''%''' ColumnNameOrIndex: 0
Variables.FindOrReplaceInDataTable.ReplaceItemInDataTableByColumnIndex DataTable: CSVTable AllMatches: True ValueToFind: $'''*KZ10''' MatchCase: False MatchEntireCellContents: False TextToReplaceWith: $'''%''%''' ColumnNameOrIndex: 0
Variables.FindOrReplaceInDataTable.ReplaceItemInDataTableByColumnIndex DataTable: CSVTable AllMatches: True ValueToFind: $'''*KZ17''' MatchCase: False MatchEntireCellContents: False TextToReplaceWith: $'''%''%''' ColumnNameOrIndex: 0
Variables.FindOrReplaceInDataTable.ReplaceItemInDataTableByColumnIndex DataTable: CSVTable AllMatches: True ValueToFind: $'''*KZ20''' MatchCase: False MatchEntireCellContents: False TextToReplaceWith: $'''%''%''' ColumnNameOrIndex: 0
Variables.FindOrReplaceInDataTable.ReplaceItemInDataTableByColumnIndex DataTable: CSVTable AllMatches: True ValueToFind: $'''***''' MatchCase: False MatchEntireCellContents: False TextToReplaceWith: $'''%''%''' ColumnNameOrIndex: 0
Variables.FindOrReplaceInDataTable.ReplaceItemInDataTableByColumnIndex DataTable: CSVTable AllMatches: True ValueToFind: $'''БЕ''' MatchCase: False MatchEntireCellContents: False TextToReplaceWith: $'''%''%''' ColumnNameOrIndex: 0
SET Iter TO 0
LOOP FOREACH CurrentItem2 IN CSVTable
 IF IsEmpty(CurrentItem2[0]) THEN
 Variables.DeleteRowFromDataTable DataTable: CSVTable RowIndex: Iter
 ELSE
 Variables.IncreaseVariable Value: Iter IncrementValue: 1
 END
END

Source is (copy to clipboard, this will be updated)

TOО "БЦК" Отд. позиции Гл. книги Дата 15.07.2024
Бухтарма Страни 1
-----------------------------------------
| БЕ |ГлавКнига | Сумма в ВВ|
-----------------------------------------
|* KZ10|240001000 | 8 378 509,45 |
|* KZ10|240002000 | 135 879,27 |
|* KZ10|240003000 | 13 726,20 |
|* KZ10|240004000 | 96 206,28 |
|* KZ10|240005000 | 0,00 |
|* KZ10|240007000 | 0,00 |
|* KZ10|240009000 | 0,00 |
|* KZ10|240010000 | 0,00 |
|* KZ10|240012000 | 502 960,27 |
|* KZ10|240013000 | 0,00 |
|* KZ10|240014000 | 0,00 |
|* KZ10|240016000 | 0,00 |
|* KZ10|240017000 | 199,00 |
|* KZ10|240018000 | 0,00 |
|* KZ10|240019000 | 0,00 |
|* KZ10|240020000 | 0,00 |
-----------------------------------------
|** KZ10| | 9 127 480,47 |
-----------------------------------------
|* KZ17|240001000 | 0,00 |
|* KZ17|240002000 | 325,00 |
|* KZ17|240003000 | 45 070,00 |
|* KZ17|240004000 | 560 640,00 |
|* KZ17|240005000 | 0,00 |
|* KZ17|240006000 | 0,00 |
|* KZ17|240007000 | 9 161,50 |
|* KZ17|240008000 | 950,00 |
|* KZ17|240009000 | 0,00 |
|* KZ17|240010000 | 209 500,00 |
|* KZ17|240011000 | 258 805,00 |
|* KZ17|240012000 | 0,00 |
|* KZ17|240013000 | 26 508,00 |
|* KZ17|240014000 | 0,00 |
|* KZ17|240015000 | 45 040,10 |
|* KZ17|240016000 | 0,00 |
|* KZ17|240017000 | 0,00 |
|* KZ17|240018000 | 0,00 |
|* KZ17|240019000 | 0,00 |
|* KZ17|240020000 | 1 482 675,00 |
|* KZ17|240021000 | 296 014,00 |
|* KZ17|240022000 | 1 372 655,00 |
-----------------------------------------
|** KZ17| | 4 307 343,60 |
-----------------------------------------
|* KZ20|240001000 | 0,00 |
|* KZ20|240003000 | 0,00 |
|* KZ20|240004000 | 135 879,70 |
|* KZ20|240005000 | 3 335,38 |
|* KZ20|240006000 | 64 900,19 |
|* KZ20|240007000 | 0,00 |
|* KZ20|240008000 | 109 776,00 |
|* KZ20|240009000 | 51 545,00 |
|* KZ20|240010000 | 0,00 |
|* KZ20|240011000 | 0,00 |
|* KZ20|240012000 | 0,00 |
|* KZ20|240013000 | 0,00 |
|* KZ20|240014000 | 979,20 |
|* KZ20|240015000 | 0,00 |
|* KZ20|240016000 | 51 375,00 |
|* KZ20|240017000 | 0,00 |
|* KZ20|240018000 | 0,00 |
-----------------------------------------
|** KZ20| | 417 790,47 |
-----------------------------------------
|*** | | 13 852 614,54 |
-----------------------------------------

Andrey86 14 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi
Source is text from clipboard:
TOО "БЦК" Отд. позиции Гл. книги Дата 15.07.2024
Бухтарма Страни 1
-----------------------------------------
| БЕ |ГлавКнига | Сумма в ВВ|
-----------------------------------------
|* KZ10|240001000 | 8 378 509,45 |
|* KZ10|240002000 | 135 879,27 |
|* KZ10|240003000 | 13 726,20 |
|* KZ10|240004000 | 96 206,28 |
|* KZ10|240005000 | 0,00 |
|* KZ10|240007000 | 0,00 |
|* KZ10|240009000 | 0,00 |
|* KZ10|240010000 | 0,00 |
|* KZ10|240012000 | 502 960,27 |
|* KZ10|240013000 | 0,00 |
|* KZ10|240014000 | 0,00 |
|* KZ10|240016000 | 0,00 |
|* KZ10|240017000 | 199,00 |
|* KZ10|240018000 | 0,00 |
|* KZ10|240019000 | 0,00 |
|* KZ10|240020000 | 0,00 |
-----------------------------------------
|** KZ10| | 9 127 480,47 |
-----------------------------------------
|* KZ17|240001000 | 0,00 |
|* KZ17|240002000 | 325,00 |
|* KZ17|240003000 | 45 070,00 |
|* KZ17|240004000 | 560 640,00 |
|* KZ17|240005000 | 0,00 |
|* KZ17|240006000 | 0,00 |
|* KZ17|240007000 | 9 161,50 |
|* KZ17|240008000 | 950,00 |
|* KZ17|240009000 | 0,00 |
|* KZ17|240010000 | 209 500,00 |
|* KZ17|240011000 | 258 805,00 |
|* KZ17|240012000 | 0,00 |
|* KZ17|240013000 | 26 508,00 |
|* KZ17|240014000 | 0,00 |
|* KZ17|240015000 | 45 040,10 |
|* KZ17|240016000 | 0,00 |
|* KZ17|240017000 | 0,00 |
|* KZ17|240018000 | 0,00 |
|* KZ17|240019000 | 0,00 |
|* KZ17|240020000 | 1 482 675,00 |
|* KZ17|240021000 | 296 014,00 |
|* KZ17|240022000 | 1 372 655,00 |
-----------------------------------------
|** KZ17| | 4 307 343,60 |
-----------------------------------------
|* KZ20|240001000 | 0,00 |
|* KZ20|240003000 | 0,00 |
|* KZ20|240004000 | 135 879,70 |
|* KZ20|240005000 | 3 335,38 |
|* KZ20|240006000 | 64 900,19 |
|* KZ20|240007000 | 0,00 |
|* KZ20|240008000 | 109 776,00 |
|* KZ20|240009000 | 51 545,00 |
|* KZ20|240010000 | 0,00 |
|* KZ20|240011000 | 0,00 |
|* KZ20|240012000 | 0,00 |
|* KZ20|240013000 | 0,00 |
|* KZ20|240014000 | 979,20 |
|* KZ20|240015000 | 0,00 |
|* KZ20|240016000 | 51 375,00 |
|* KZ20|240017000 | 0,00 |
|* KZ20|240018000 | 0,00 |
-----------------------------------------
|** KZ20| | 417 790,47 |
-----------------------------------------
|*** | | 13 852 614,54 |
-----------------------------------------
Andrey86 14 on at

Like
a
(1)

Report
Copy link

Link copied!

PAD flow:
Variables.CreateNewDatatable InputTable: { ^['БЕ', 'Кассовая книга', 'Основной счет', 'Начальное сальдо', 'Сумма прихода наличных', 'Сумма поступивших чеков', 'Сумма выдачи наличных', 'Остаток', 'из них наличные', 'СуммаGl', 'Разница'], [$'''KZ10''', $'''KZT1''', 240001000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ10''', $'''KZT2''', 240002000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ10''', $'''KZT3''', 240003000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ10''', $'''KZT4''', 240004000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ10''', $'''KZT5''', 240005000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ10''', $'''KZT6''', 240006000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ10''', $'''KZT7''', 240007000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ10''', $'''KZT8''', 240008000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ10''', $'''KZT9''', 240009000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ10''', $'''KZ10''', 240010000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ10''', $'''KZ11''', 240011000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ10''', $'''KZ12''', 240012000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ10''', $'''KZ13''', 240013000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ10''', $'''KZ14''', 240014000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ10''', $'''KZ15''', 240015000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ10''', $'''KZ16''', 240016000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ10''', $'''KZ17''', 240017000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ10''', $'''KZ18''', 240018000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ10''', $'''KZ19''', 240019000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ10''', $'''KZ20''', 240020000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ17''', $'''KZT1''', 240001000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ17''', $'''KZT2''', 240002000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ17''', $'''KZT3''', 240003000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ17''', $'''KZT4''', 240004000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ17''', $'''KZT5''', 240005000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ17''', $'''KZT6''', 240006000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ17''', $'''KZT7''', 240007000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ17''', $'''KZT8''', 240008000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ17''', $'''KZT9''', 240009000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ17''', $'''KZ10''', 240010000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ17''', $'''KZ11''', 240011000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ17''', $'''KZ12''', 240012000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ17''', $'''KZ13''', 240013000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ17''', $'''KZ14''', 240014000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ17''', $'''KZ15''', 240015000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ17''', $'''KZ16''', 240016000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ17''', $'''KZ17''', 240017000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ17''', $'''KZ18''', 240018000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ17''', $'''KZ19''', 240019000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ17''', $'''KZ20''', 240020000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ17''', $'''KZ21''', 240021000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ17''', $'''KZ22''', 240022000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ20''', $'''KZT1''', 240001000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ20''', $'''KZT2''', 240002000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ20''', $'''KZT3''', 240003000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ20''', $'''KZT4''', 240004000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ20''', $'''KZT5''', 240005000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ20''', $'''KZT6''', 240006000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ20''', $'''KZT7''', 240007000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ20''', $'''KZT8''', 240008000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ20''', $'''KZT9''', 240009000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ20''', $'''KZ10''', 240010000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ20''', $'''KZ11''', 240011000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ20''', $'''KZ12''', 240012000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ20''', $'''KZ13''', 240013000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ20''', $'''KZ14''', 240014000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ20''', $'''KZ15''', 240015000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ20''', $'''KZ16''', 240016000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ20''', $'''KZ17''', 240017000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''], [$'''KZ20''', $'''KZ18''', 240018000, $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $'''''', $''''''] } DataTable=> DataTable
Clipboard.GetText Text=> ClipboardText
Text.SplitText.Split Text: ClipboardText StandardDelimiter: Text.StandardDelimiter.NewLine DelimiterTimes: 1 Result=> TextList
Variables.GenerateDataTableFromCSV.ReadCustomSeparator CSVText: TextList TrimFields: True FirstLineContainsColumnNames: False ReadFieldsAsText: False CustomColumnsSeparator: $'''|''' CSVTable=> CSVTable
Variables.DeleteColumnFromDataTable.DeleteColumnWithIndex DataTable: CSVTable ColumnIndex: 0
Variables.DeleteColumnFromDataTable.DeleteColumnWithIndex DataTable: CSVTable ColumnIndex: 3
Variables.FindOrReplaceInDataTable.ReplaceItemInDataTableByColumnIndex DataTable: CSVTable AllMatches: True ValueToFind: $'''* ''' MatchCase: False MatchEntireCellContents: False TextToReplaceWith: $'''%''%''' ColumnNameOrIndex: 0
Variables.FindOrReplaceInDataTable.ReplaceItemInDataTableByColumnIndex DataTable: CSVTable AllMatches: True ValueToFind: $'''*KZ10''' MatchCase: False MatchEntireCellContents: False TextToReplaceWith: $'''%''%''' ColumnNameOrIndex: 0
Variables.FindOrReplaceInDataTable.ReplaceItemInDataTableByColumnIndex DataTable: CSVTable AllMatches: True ValueToFind: $'''*KZ17''' MatchCase: False MatchEntireCellContents: False TextToReplaceWith: $'''%''%''' ColumnNameOrIndex: 0
Variables.FindOrReplaceInDataTable.ReplaceItemInDataTableByColumnIndex DataTable: CSVTable AllMatches: True ValueToFind: $'''*KZ20''' MatchCase: False MatchEntireCellContents: False TextToReplaceWith: $'''%''%''' ColumnNameOrIndex: 0
Variables.FindOrReplaceInDataTable.ReplaceItemInDataTableByColumnIndex DataTable: CSVTable AllMatches: True ValueToFind: $'''***''' MatchCase: False MatchEntireCellContents: False TextToReplaceWith: $'''%''%''' ColumnNameOrIndex: 0
Variables.FindOrReplaceInDataTable.ReplaceItemInDataTableByColumnIndex DataTable: CSVTable AllMatches: True ValueToFind: $'''БЕ''' MatchCase: False MatchEntireCellContents: False TextToReplaceWith: $'''%''%''' ColumnNameOrIndex: 0
SET Iter TO 0
LOOP FOREACH CurrentItem2 IN CSVTable
IF IsEmpty(CurrentItem2[0]) THEN
Variables.DeleteRowFromDataTable DataTable: CSVTable RowIndex: Iter
ELSE
Variables.IncreaseVariable Value: Iter IncrementValue: 1
END
END
Andrey86 14 on at

Like
a
(1)

Report
Copy link

Link copied!

PAD flow and Source attached

PAD_Flow.zip
Sayan 818 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Hey @Andrey86
If you have Two DataTable have same number of rows please check the following solution Just modify the Column Names and the Index Number.
**REGION Set Variable
SET FirstCondition TO $'''False'''
SET SecondCondition TO $'''False'''
Variables.CreateNewDatatable InputTable: { ^['Column1', 'Column2', 'Column3'], [$'''KZ10''', 240001000, $''''''], [$'''KZ10''', 240002000, $''''''], [$'''KZ10''', 240003000, $''''''], [$'''KZ17''', 240001000, $''''''], [$'''KZ17''', 240002000, $''''''], [$'''KZ17''', 240003000, $''''''], [$'''KZ17''', 240004000, $''''''] } DataTable=> DataTable1
Variables.CreateNewDatatable InputTable: { ^['Column1', 'Column2', 'Column3'], [$'''KZ10''', 240001000, 837850945], [$'''KZ10''', 240002000, 12387925], [$'''KZ10''', 240003000, 78945], [$'''KZ17''', 240001000, 45678], [$'''KZ17''', 240002000, 12345], [$'''KZ17''', 240003000, 12345], [$'''KZ17''', 240004000, 75395] } DataTable=> DataTable2
SET RowCount TO DataTable1.RowsCount - 1
**ENDREGION
LOOP LoopIndex FROM 0 TO RowCount STEP 1
SET IndexNumber TO 0
IF DataTable1[LoopIndex][0] = DataTable2[LoopIndex][0] THEN
SET FirstCondition TO $'''True'''
END
IF DataTable1[LoopIndex][1] = DataTable2[LoopIndex][1] THEN
SET SecondCondition TO $'''True'''
END
IF FirstCondition = SecondCondition THEN
SET DataTable1[LoopIndex][2] TO DataTable2[LoopIndex][2]
SET FirstCondition TO $'''False'''
SET SecondCondition TO $'''False'''
END
Variables.IncreaseVariable Value: IndexNumber IncrementValue: 1
END
If you need anything, please reply.
------------------------------------------------------------------------------------------------------------------------------
If my suggestion helps you, please gives it a Thumbs up 👍 and Marks as a Solution ✔️. Which motivates to solve more problems.
Thanks,
Sayan Patra | RPA Developer
Andrey86 14 on at

Like
a
(1)

Report
Copy link

Link copied!

No, they have a different columns and rows count. And statments (rows in table2) can be moved and not stay at the same line