Hi, I have a datatable dt and based on some date conditions I need to add the rows with updated values to a new datatable. Input dt: [image] Output dt: [image] Also please refer the attached file for the whole input & output sample. Test1.xlsx (11.8 KB) The output dt is based on how many ti…

Hi, Sorry, it seems the above sample was not considered about the last row. Can you try the following ? Sample20240619-3 (2).zip (15.7 KB) Regards,

hi~ you can use “filter data table”, reference is as follows 1. [image] [image] 3. [image] Main.xaml (3.2 KB)

HI, How about the following sample? [image] Sample Sample20240619-3.zip (14.5 KB) Regards,

Thanks Yoichi! Helpful as always :slight_smile:

Hi Yoichi, The last row if it has a retail with Start Date 12/26/2023 & End date 1/1/2024 gets truncated in the output. Not sure why. All other logic seems fine and working.

Add data row based on Retail value check

Help Studio

SunnyJha (Sunny Jha) June 19, 2024, 3:27am 3

If you see the dates the values are updated as per how many consecutive times a retail value is repeated. We have to incorporate that logic as well.

Modify & Add data to new dt based on certain conditions

Topic		Replies	Views
Modify & Add data to new dt based on certain conditions Studio studio , question , activities_panel	2	109	June 19, 2024
Add data row based on date check Studio studio , question , activities_panel	3	186	June 10, 2024
How to add data to a data table while the data is being read from the same Table Activities excel	5	645	April 22, 2021
Need to append datatable if the next value is already present Activities datatable , excel , selector , uiautomation , mail , orchestrator , robot , activities , studio , data_scraping , studiox , question , activities_panel	19	1458	October 27, 2022
Cover information in duplicate data row Academy Feedback studio , question	8	1366	July 15, 2020

Add data row based on Retail value check

Related topics