Considering some rows of a data table

[kartik_sareen (KRK)]

I have a white data table in which I have only white rows so from the screenshot, u can say that 4 rows I have in the data table but now I want to throw an exception if Product type and Transaction type in notNTT and 102. Could u guide me a bit on this…

[Palaniyappan (Palaniyappan P)]

Fine
Hope these steps would help you resolve this
—use a TRY catch activity and inside the TRY a block use excel application scope and pass the file path as input
—inside the scope use read range activity and get the output with a variable of type datatable named dt
— now use a for each row loop and pass the above variable dt as input
—inside the loop use a IF condition like this
NOT row(0).ToString.Equals(“NTT”) AND NOT row(1).ToString.Equals(“103”)
—if true it will go to THEN part where we can use a
THROW activity And mention like this
New BusinessException(“yourmessage”)
—if the exception occurs it will go to CATCH block where we can send a note to user that “there occurs a exception” with a send outlook mail activity.

Cheers @kartik_sareen

[Luis261980 (Luis Nunes)]

Hi, @kartik_sareen or u can use for each row and inside use if row(1).tostring.equals(“NTT”) and row(2). tostring.equals(“102”)

[ppr (Peter Preuss)]

@kartik_sareen

An alternate with less required activities could look like following:

• readin Excel into a datatable as described by Palaniyappan
• count the occurence of NTT 102 rows
• react on the count within a if activity

Assign Activitiy:
NTT102Count is of Datatype Int32
Statement: YourDataTableVar.AsEnumerable.Where(Function (row) row(1).ToString.Equals(“NTT”) And row(2).ToString.Equals(“102”)).Count

For Demo Purposes I used Message Boxes

Ensure that the DataSetExtenstions are available:

AsEnumerable is not a member of 'System.Data.Datatable'

Hi @lucas.mcgonagle EDIT 20.10 fixed this issue for newly created projects. You can fix it by adding the Assembly Reference manually in your xaml file: [image] Simply open the file in Notepad and create new line with this String: <AssemblyReference>System.Data.DataSetExtensions</AssemblyReference> Then reopen your project and the error should be gone. Please be careful while doing so and always keep a backup.

[kartik_sareen (KRK)]

Thank you Palaniyappan,

I have used the same but I am geting an error
compiler error
which says thats System.Data.Datatable to Systems.Collections.IEnumerable , could u help me in this .

VarWhiteDt is a data table

[Palaniyappan (Palaniyappan P)]

Kindly use FOR EACH ROW activity
You have used FOR EACH activity
Cheers @kartik_sareen

[kartik_sareen (KRK)]

Thanks a lot buddy

[kartik_sareen (KRK)]

I have a data table as mentioned above but in that I need to add all the values in the column 17.
example:
So the position is 17th, I need to add all the values in a data table at position 17th.could u guide me a bit.