Hi All, I have a scenario in excel. I will be having some set of data and few rows having additional data as well. When i read any data. I need to get the subsequent rows also either using INVOICE or S.No columns
I have attached excel sheet including INPUT and my Required OUTPUT. Can anyone guide me to solve this issue
Test Scenario.xlsx (12.4 KB)
Hi,
Based on your sample sheet, and assuming your data is always starting at cell A1, you should be able to get the data using a Read Range Workbook activity without specifying the range.
Hey you need to have row values to store the current row index
You can assign for each loop and see if the based on the current index if next row values is null or not and the till the values is null
Will be your second reference
This references u can pass it to read range activity every time
Hi @jast1631 row index will increment right always. you mean to say first i need to check whether it’s null or having value then needs to increment index
Yes and store into one more variable which u can use to pass it to read range
like the value storing variable will be data table only right or it’s different which you are saying
No index value storing variable will be different
And the data table both will be different
@jast1631 If you can please share me any sample code. It will be helpful, Having little confusion
Sure allow me sometime
@jast1631 Sure, thanks
Data.zip (22.5 KB)
Please check this code,hope this helps. I am storing the result in Copy file, check file names while you are going through. Let me know in case of anything.
Thanks
@Rreddy
Thanks @jast1631 . This will help me. I will alter it based on some more conditions. Thank you
Please mark this as solved as it will be helpful ,
Thanks
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.