Problem In DataRow Table

Help Activities
,
1

I have a datatable and iterrate one by one value but how can i use the assign value in my if condition

Screenshot 2022-08-04 182059
Screenshot 2022-08-04 182059918×698 21.9 KB

2

please elaborate more on your question. Thanks

3

Hey @Himanshu_Pratap_Rana

You want to assign a value to Datatable ?

Thanks
#nK

4

Actually I have a datatable and i want read the account detail from datatable and change in string.
Becuause i want use if condition when value meet then show message.

5

maybe we can optimize the check. Can you share some sample data and the statement from:
grafik

thanks

6

Page1
Page1745×897 61.6 KB

Strings.Right(CurrentRow(“AccountNumber”).ToString,4)
input.xlsx (10.6 KB)
I want account last 4 digit number and check in if condition that meet in excel then show a message.

7

when looking to your last screenshot we do see that there was a change (shift away from ItemArray usage)

Currently we do see that String_Value is taking the last 4 chars
The if condition will be allways true as it is comparing same value with a contains to the last 4 chars
grafik

We would suggest to share with us:

  • elaborate more on your business case?
  • what is the remaining open problem in detail?