Hello Guys,
Iam reading data only from blank remark column and i have used a lookup table to get the row index of blank blank status cell.
And i want to write remarks in the next remark column.
See when the blank space is 3 it is adding remarks in the second row (Status column)
@debojyoti_ghosh
Can you help me out on this
Hi @Gokul_Murali
find_empty.xaml (20.6 KB)
You can Use this to check if the next row is blank or not if black or empty you can append the value.
@debojyoti_ghosh
its not working
Can you please try this one
Also in the for each loop you can try with String.isNullorWhiteSpace if thats true then pest the string you want to put.
Iam using RE Framework so is that be a good one
We need to get the datatable to find the blank space.
Or you can Use a datatable and use append range.
Hi @Gokul_Murali - Can you check the value in in_RowIndex by using message box. It seems that in_RowIndex has value Zero. Hence it is writing the value in AC2
I used message box to check the rowindex but its showing only AC2 for every transaction.
Used assign activity to update the rowindex +1 also in process workflow still showing the same AC2 index
I see some difference here…in the look up you used rowindex and in the write cell you are using in_rowindex…I believe both are not same can you please check and confirm
And did you check if lookup id empty is giving the correct value?
Cheers
parvathi_ayanala
jamiejam
Anirudh_Tugawe