Hi communty,
I would like to ask how do we build the formula so that it will read the first line of row data instead of reading each line of excel data.
Many thanks
Hi @Pavanraj_Shetty ,
Many thanks for the response. How do i proceed the next step once i add the read range? As i try to use type into function and would like to ask how do we build the formula under the type into function.
Many thanks
Place type into inside for each loop so you can loop through each loop
Cheers,
HI @Pavanraj_Shetty ,
Many thanks for the prompt response. reason being i asked this is currently i have few parameter in SAP need to fill in
For the first type of parameter, i would need to read first line in excel file
For second time of parameter, i would need to read each line in excel file.
Currently i have one datable and it fit the second parameter whereby i will read each line of datatable by using each row function.
Can i use the same datable for the first type of parameter and using each row function?
Many thnks
Hi @SH_94
In Properties “Add Headers” uncheck the option.So you can read first row for “Read Range Activities”
Using if condition you can seperate first row and other remaining rows
Cheers,