Adding specific excel items to queue

Good day

Please see below image

I am using orchestrator and i need to add each SR Ref as seperate queue items but only the ones with the “Y” alert

image

Hello @Ziyaad_Conrad1,

  1. Use “Read Range” activity to read all rows
  2. Use “Filter Data Table” activity to get only rows with Y (Alert column)
  3. Use “Bulk Add Queue Items” activity to add all rows at the same moment to your queue (each row will be one separated queue item). If you prefer, you can use “Add Queue Item” activity, in this case, you need to use a “For Each Row” activity too.

If you need more details, please let me know.

Hi @Ziyaad_Conrad1

You can check this post might help you.

Thanks
Latika

1 Like

Thanks for the information. How would i use the filter data table to get only the with Y? looks very confusing

1 Like

Never mind i managed to figure it out. I used assign to replace the rest that i do not need with nothing and came with the output i need

1 Like

Any time my friend :slight_smile:

Glad to help you!

Nice that you managed to figure it out, anyway… in a short time I will show ho you can use “Filter Data Table” in this case.

@Ziyaad_Conrad1

Here you go…

Don’t forget to change “InputDataTable” variable.

Filter Rows Tab:

image

Output Columns tab:

image