Help me in creating linq or any other method for this

[Jorie_02]

I have datatable like this

I want the blank cells in column1 to fill like this

[vrdabberu (Varunraj Dabberu)]

Hi @Jorie_02

PLease check the below thread

Fill Data table empty cell with last filled cell in column

Hi, Can you try the following expression? dt = dt.AsEnumerable.Select(Function(r,i) dt.Clone.LoadDataRow({dt.AsEnumerable.Where(Function(r2,i2) i2<=i andAlso not String.IsNullOrEmpty(r2(0).ToString)).Last.Item(0).Tostring,r(1)},False)).Where(Function(r) not String.IsNullOrEmpty(r(1).ToString)).CopyToDataTable() Regards,

Regards

[vrdabberu (Varunraj Dabberu)]

Hi @Jorie_02

Use the below in Assign activity:

dt1 = dt1.AsEnumerable.Select(Function(r,i) dt1.Clone.LoadDataRow({dt1.AsEnumerable.Where(Function(r2,i2) i2<=i andAlso not String.IsNullOrEmpty(r2(0).ToString)).Last.Item(0).Tostring,r(1)},False)).Where(Function(r) not String.IsNullOrEmpty(r(1).ToString)).CopyToDataTable()

workflow:

Sequence1.xaml (10.9 KB)

Input:

Output:

[ppr (Peter Preuss)]

Done within an essential modelling:

E.g.
Before:

After Fillup: