How to add rows in existing datatable

Help StudioX
1

Hii,
My requirement is like i want to compare the values of two datatables based on two columns.
If both the Column values of datatable2 contains in datatable 1,then i need to take both the values of datatable1 ,add one row in datatable2 just below the matched value and paste the value of datatable 1.

How to do itt pls help

3

Hi @Tabbu

Sorry I didn’t saw the tag mentioned!

Please refer to logic skeleton xaml below!

Main.xaml (11.8 KB)

Regards

4

Getting error .
Collection was modified; enumeration operation might not execute

5

Hi @Tabbu

Not much familiar with Studio-X

Looping @Yoichi to have a view on the above!

Regards

6

Using studio pro

7

Hi @Tabbu

Enable classic option from the activities filter!

image
image727×485 20.2 KB

and try with the xaml below!

Main.xaml (10.0 KB)

Regards

8

This is not working as per the requirement

9

@Tabbu

Try appending outstide the body of loop!

Regards

10

Not that also not working

11

Hi @Tabbu

Can we have the input and Excepted output Screenshot!

Regards

12

16411957128191643074517
164119571281916430745171920×960 136 KB

The above is input file.
Like this i have two input files.The data is same as this file only the column name changes and all the data are unmerge in second input file,unlike above input file.

16412043535661659605410
164120435356616596054101920×960 254 KB

Here is the ouput sheet.

Note: where .mht is written is the second input file and where Excel is written is the first input file.

The requirement is like we can have any number of .mht input file and for that only one excel file is there.
If 3 .mht file is there so we will compare one row of excel with 3 .mht file.

Here we need to get unique value of column Entrycode, Col_D, Deal and Z_deal.

Note that in 1st input excel file thr Entry code and Col_D column is merged but in output it is unmerged.

Please helppp!!
I m stuck in a project

13

Hi @Tabbu

Cant able to understand your query much clearly!

Adding @kirankumar.mahanthi1 @Jobin_Joy @Robinnavinraj_S @THIRU_NANI @Sudharsan_Ka to have a look on the above!

Regards

2 Likes
14

Hi! @Tabbu,

It’s difficult to understand your query. can we divide the topic.

May i know what will be the first case we need to achieve from your input excels?

Adding @lakshman @Palaniyappan @supermanPunch @arivu96 @Yoichi

Regards,
NaNi

15

Yess okay,
Firstly,There 2 input files which are similar but one file we need to consider it excel file and other one is extracted from web,so second file is .mht file we will consider .

First we need to check Entry number ,Entry Name and Numbrr of both the files.
If these three are match then only we will proceed ahead.

But the position of these column of both the file is not static.

Till here if clear please confirm