Create your first automation in just a few minutes.Try Studio Web →
by Boundaryless Group
5
Snippet
604
Is possible to merge the content of the cells on the same column (only one excel file) that are equals?
Hi Jhana,
If I understood your question correctly...
What you want to do is, to merge the content of the same column if they are equal.
So are you looking for something more of a data row merge if the cell values are similar?
If so, it is possible. But it is not a feature of this component. But you can easily write a simple logic on the datatable to merge the content
Hi Lahiru,
I have two workbooks. The first one contains 9 sheets and the second one only one sheet. My output file only capture data of the last sheet on the first workbook + the content of the second workbook, which only contains one sheet. Can you please help me to figure out the reason why the 8 remaining sheets (1 to 8) are not being processed? Thanks.
Hi Naasson
Hmm.. this is weird.. In the template, it should capture all the sheets of a particular file without a problem. In your workflow, does it still have the Assign actvity which I have named as Get Sheets? What this activity do is, it will get the list of sheets of the excel file and use a for each activity below to process each sheet..
May I know whether you still have it or?
Hi Lahiru,
If column names are different then will it merge Horizantally or Vertically ?
Hi bro,
Column names can be different.. However, the structure of the datatable should be the same for this template to work. However, if you can include a small column check logic, we can make the structure dynamic too easily
License & Privacy
MIT
Privacy Terms
Technical
Version
2.0.0Updated
November 12, 2020Works with
Studio: 19.5 - 22.10
Certification
Gold Certified
Support
Email: lahiru@boundaryless.com
Mon-Fri 8 AM to 9 PM IST; Response time: 1 business day; Resolution time: 10 days