How to add items to queue with condition

[NISHITHA]

Hello Team,

We have a column in below format

Project | D_Name | cn_no

It should only add items for these columns if all three columns contain value

Value should not be added into queue if present in below format

Example:If only Project/D_Name/cn_no any one column contains the value then that row should not be added to queue

Project | D_Name | cn_no
| | 881
qne | |
| nnk |
P1 | ddk |990

Only P1 row should get added to queue

Thanks in advance

[rodrigo.simao]

Hello @NISHITHA, try this:

Read Range (Excel) → DataTable

Filter Data Table:

• Input: DataTable
• Conditions: Project is not empty AND D_Name is not empty AND cn_no is not empty
• Output: FilteredDataTable

For Each Row (FilteredDataTable):

• Add the current row to the queue

Cheers!

[Shiva_Nikhil]

hi @NISHITHA

can you try this

[ppr (Peter Preuss)]

Assign Acitvity

dtChecked =

( From d in YOurDataTableVar.AsEnumerable()
Let isBlank = d.ItemArray.All(Function (x) isNothing(x) OrElse String.IsNullOrEmpty(x.toString.Trim))
Where not isBlank
Select r = d).CopyToDatable

[NISHITHA]

Thanks @rodrigo.simao , @Shiva_Nikhil and @ppr for your quick responses