Merge data

Fine lets check what is there in the merged datatable
next to the merge datatable use a output datatable activiy and mention the input as Finaldt
and use a write line activity with the above output variable
–all inside the for each loop

Kindly share that screenshot pls

Cheers @balkishan

2 Likes

when we change the alternative of data table it worked.
But it not merged the data. Only writing the first excel data from A cell

2 Likes

Great
i think the reason is this @balkishan

–i hope you might have mentioned the range in specifc while reading
is it so

Cheers @balkishan

2 Likes

Kindly try this and solve this up buddy

2 Likes

**Bro I know I can further read this file using the excel application scope. and use the write range to create the new file and it gives us the correct output with data writing start from the A1. **
But we have check here also why it’s giving the data start from Y cell.

1 Like

no worries
Kindly share me the workflow and both the input files all together in a zipped folder
Cheers @balkishan

2 Likes

It resolved bro. I added further activity to read again and final write into the merged file.

2 Likes

Fantastic
Cheers @balkishan

1 Like

Thanks @Palaniyappan

2 Likes

no worries @balkishan

1 Like

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