@lakshman Hi I am getting this error
@lakshman now it is executing successfully but not showing any data which I need to insert column processing status fail and column exception reason amount greater then 60 right now these column showing me empty
@AshwinS2 Its executing but not able to insert these value in column amount is false
column name “Amount is greater than 30”
right now both the column showing empty
Hi use
Dt.columns(“column name”). expression=“Amount is greater than 30”
Thanks
Ashwin.S
@AshwinS2 I used this throwing error as mentioned in attachment
@AshwinS2 now
getting this error
Remove expression
Thanks
Ashwin.S
@lakshman shell you suggest me…?
@sandeep13 can you please help me…???
Hello @Aditya10989
You assign value in datarow?? Right
Hello @Aditya10989
You can not assigned value in data table like you do. If you remember level 3 assignment 1 we use such activity
You should create data row activity then assign in data table in datarow property.
I not remember exactly property name
Thanks
Any reason you would not use an excel formula for this? In some solutions I create a blank template file that I then put data into from the source. I keep my formulas in the excel template to keep things simple.
Place in Z column
=IF(V2>60,“Fail”,“Good”)
Place in AA column
=IF(V2>60,“column processing status fail and column exception reason amount greater then 60”,“”)
@sandeep13 Thank you very much
@LeftBrainCo Thank you very much