Excel merge read range for multiple ranges

Help Studio
, , , ,
1

Hey Team,

Is there a way to merge read range outputs in Excel for multiple ranges without having to use the read range activity 6 times?

RR
RR1949×754 52.1 KB

2

HI @uiStijn

That is not possible either you need to read it completely and then filter them and then get the data with expression or you need to use six read range

Regards
Sudharsan

1 Like
3

Hi @uiStijn

Can you try with this method

  • You can use multiple read range activities for each range and then use merge data table activity to combine them into one data table, if the number of columns of the ranges is all the same.

  • You can use append range activity to append data from different sheets or workbooks into one sheet and then use read range activity to read the whole sheet into a data table, if the structure of the data is consistent.

Check out this blog

Regards
Gokul

1 Like
4

Hey guys, i fixed it with this Assign:

MergedDatatable = extracted_bas_Value_0_1_2_3.AsEnumerable().Concat(
extracted_bas_Value_4_5.AsEnumerable()).Concat(
extracted_bas_Value_6_7.AsEnumerable()).Concat(
extracted_bas_Value_8_9.AsEnumerable()).Concat(
extracted_bas_Value_10_11_12_13.AsEnumerable()).Concat(
extracted_bas_Value_14_15.AsEnumerable()).CopyToDataTable()

5

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