Excel, Database, Row Delete

Help Studio
, ,
1

Hello All,

I have a following input,

From Date = “12/22/2023” , RowCount=6
ToDate = "12/28/2023’, RowCount=1

The below mentioned screenshot is my dt.
image

I would need a output like follow,

image

Means I need to get the table from 12/22/2023 6 to 12/28/2023 1 in the table

Is there any possibilities.

Thanks in Advance

2

@manikandan.murugan

Use filter datatable activity for this.
And sort datatable by date column

Thanks,
Ashok :slightly_smiling_face:

1 Like
3

Hey @manikandan.murugan

Please confirm that output table will have 4 rows? cause you have added 12/23/2023 twice!

Regards,
Ajay Mishra

1 Like
4

you can check the skipWhile combined with a takeWhile approach

5

Yes output will have 4 rows @Ajay_Mishra

6

@manikandan.murugan You need a static output for this particular input or your input can change accordingly?

7

Input will change the input I provided as a sample

8

kindly note, as we gave the first option:

Another strategy could be to retrieve the row index from the first row and last row and using skip / take

9

@manikandan.murugan Okay so, the explanation given by you will generate a static output and I can provide you static solution but, can you elaborate more about input datatable and dynamic condition that will be applicable in all scenarios?

Regards,
Ajay Mishra

10

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