How to split 2 data table from single sheet

[RajKumarDuraiFAS (RajKumar Durai)]

Hi All,

I have single sheet and I need split 2 Data table using below range

Dt1: (A:H)
Dt2: (J:R)

then Dt1 and Dt2 range will be dynamically change

@Palaniyappan
@Yoichi

[Gokul001 (Gokul Balaji)]

Hi @RajKumarDuraiFAS

Have a look on the XAML file

Split@2DT.xaml (5.4 KB)

Regards
Gokul

[Yoichi]

Hi,

It might be better to use ReadRangeX as the following.

Regards,

[RajKumarDuraiFAS (RajKumar Durai)]

Hi @Gokul001 ,

im getting 10L empty rows

if i try to write dt getting below error

[Sanjit_Pal]

Hey @RajKumarDuraiFAS,

Use filter activity to remove the empty rows, as you are reading the range from A:H that why it might considering all the rows between that range.

Filter:- Remove
Name isEmpty

Thanks,
Sanjit