Join DataTable Issue

Help Studio
, , , , , ,
1

Hello Team,

We are working with csv files

These are the activities being performed
1)Read csv file 1 (dt1)
2)Read Excel File(dt2)
3)Join Both
We get Art1 and Uan from dt2 into dt1 where Column1 value is same as Art1
And generate Final Table

Have attached image for better understanding

image
image1242×417 18.3 KB

Have used Join data table activity

But in case of large data its giving error message Job stopped with…

Could we use other approaches

Thanks Everyone

2

@anmita

In case of lrge data is it stopping at join or reading the data?

Cheers

3

Hi @anmita ,

Could you maybe also let us know approximately how large is the data (On both files)? Also, are you using datatable arguments or as variables ?

4

Hi @Anil_G and @supermanPunch

Its stopping while execution of join data table

The data is around approx 60k

Have read csv and excel and used as data table

5

@anmita

Did you try with excel workbook activities?

alternately you can try to use excel as DB and read read as well…which might support larger data

cheers

6

Hello @Anil_G

For Reading csv yes have used it

For Excel have used read range workbook

7

@anmita

For excel try with excel as DB

Cheers

8

@Anil_G could you explain a bit more in detail like which approach

9

@anmita

Please check this

Cheers

10

@supermanPunch it at the join data table

That we get this exception

Job stopped with an unexpected exit code: 0xE0434352

11

@anmita

Try with linq…if the issue is at join and not at read

First use build datatable and build finaldt with required columns

Finaldt = (From d1 in dt1.AsEnumerable
Join d2 in dt2.AsEnumerable On
d1("Column1").ToString Equals d2("Art1").ToString
Select Finaldt.Rows.Add({d2("Art1").ToString,d1("D_No").ToString,d2("Uan").ToString})).CopyToDataTable

Cheers

12

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