Merge 3 excels files

Help
, , ,
1

Hello,

Can someone see what i’m missing here? I’m trying to merge 3 excel files, into one new file.

See attached file.

Merge&Filter.zip (39.0 KB)

2

@mz3bel

Try the below flow, i have just changed the way you read the excel files.

Merge&Filter.zip (39.8 KB)

3

@Ragu9060

Still the same issue with the merge data table.

4

Provide a screenshot of the error

5

@Ragu9060

The error is that Object reference not set to an instance of an objec

6

please share the resolution xml
@Ragu9060
@mz3bel

7

@Mansi_08

Already shared, once i find the solution, i ll share the xaml file.

8

The destination datatable is not initialized, try to build a datatable and then follow steps to merge

9

image
image858×289 15.1 KB

10

Someone help on this please

The data did not merge and technically it should.

See attached file.

Merge&Filter.zip (44.4 KB)

11

A few things to take care of

  1. The main data table needs to be initialized before using the same

dt_data = new DataTable [In Variable Pane]

  1. Use a temporary Datatable to store the individual excel data and merge it to the main datatable

tempDT = new DataTable [In Variable Pane]

  1. Make the temp datatable nothing after each merge

tempDT = Nothing [Assign]

1 Like
12

Hello @balaji.muralikrishna

I tried what you said before, still not working.

Sans titre
Sans titre1163×647 74.4 KB

13

@bcorrea

Hello, please help me on this, trying to learn the merge data table, but can’t find what’s the issue, or what i missed.

Thank you in advance !

Merge&Filter.zip (44.5 KB)

14

merge data table is to unite two non-empty data tables…

15

@bcorrea

With the loop i did, it shouldn’t be empty ? If so, i get an error, the thing is that i don’t get any errors, and get only the last file copied on the new file.

16

@mz3bel I don’t know if you have already found the Solution :sweat_smile: , but Just Check the NEW.xlsx file in the Zip File and see if you wanted the Output in that manner
Merge&Filter.zip (43.5 KB)

1 Like
17

@supermanPunch

Thank you for your example, please can you explain what you did exactly there?

18

@mz3bel I was experimenting actually and somehow i got the result In an Ordered fashion :joy:, I do not think it is an ideal Solution though :sweat_smile:

I have just modiified a bit, I Created Datatable that should match my Outpu. I understoood that there will be empty columns while reading the Excel , hence After reading I have remove the Empty Columns, . I renamed the Columns to match my Output DT, in this way I was able to Merge.

Although I don’t think it is an Ideal Solution

19

@supermanPunch

I see, but why delete the empty colomuns, does it mean that when it will merge, if they are empty the will erase the other data that was there before ?

Do you have any simple example for my case ?

20

@mz3bel Do you need the Empty Columns ?