This table scrapped from website : Input File : InputFiles.xlsx (11.8 KB) Need to split value from “Column-0” and same row value in “Rating” column and update in new column “subheader” as last column NOTE : Two values in “Rating” Column just want to split the value available in the same row nex…

Hi @Sathish_Kumar_S => Read Range Workbook Output → InputDt => Use the below code in Invoke Code activity OutputDt = New DataTable OutputDt.Columns.Add("Rating", GetType(String)) OutputDt.Columns.Add("Required Date", GetType(String)) OutputDt.Columns.Add("Planned Date", GetType(String)) OutputD…

Split value from one column and update in another new column - Data table

Help Studio

yedukondaluaregala (Yedukondalu_aregala) April 7, 2025, 12:10pm 5

@Sathish_Kumar_S

Got it use below file
Sequence.zip (3.1 KB)

Topic		Replies	Views
Split values from Data table and update it in another new columns Studio uiautomation	3	122	June 14, 2024
How split columns values and added to next column Activities excel , activities , question , use-excel-file , excel-tables , excelreadcolumn	11	1827	October 21, 2021
Excel Data Manipulation - NEED HELP AIUTOOO Studio excel , activities , studio , question	3	806	October 27, 2022
Split values in excel file, and write in new column in same sheet Help studio	5	1231	October 28, 2019
Split Cells to seperate 2 values and add the 2nd value to a new colum Studio studio , question , activities_panel	4	787	November 7, 2022

Split value from one column and update in another new column - Data table

Related topics