Hi,
I have a query related to splitting large excel file.
There is one excel sheet with approx 1000 rows, I need to split this excel sheet(4 columns) and write to data table based on following scenarios:
There are 4-5 occurrences of keywords “id8” and “profile.c” in column0
From 1st occurrence of “id8” to first occurence of “profile.c”, I need one data table.
From second occurrence of “id8” to second occurence of “profile.c”, I need second data table.
Needs to go on until no “profile.c” keyword is found.
@kaurM
Yeah! create variables with datatype of data table according to how may data table you need to split.
Then assign a expression like source_Datatable.select(expression for filtering columns using keywords).copytoDatatable().
Like wise you can filter and just assign to data_table variables.