How to remove a row from context list based on the constant value.

[former_member213558]

Hi All.

I want to remove some queues which has a value of  “END” from the queue, can I have a UDF to achieve this,

Actual Queue list

Expected Queue list

Regards

Ramesh

[former_member186851 · Accepted solution]

Hello Ramesh,

No need of UDF,Try the below logic.

[former_member213558 · Accepted solution]

Thank for your reply.

but here my value is quite strange, i want to remove "END" and i need to keep "Split By each value by value change"

i tired already but ...  i need to remove "END" and need to maintain queue also.

please suggest .

Regards

Ramesh

[manoj_khavatkopp · Accepted solution]

Ramesh,

Try this:   

  for (int i=0;i<inp.length;i++)

        {

            if(!(inp[i].equals("END")))

            result.addValue(inp[i]);

        }

take input as queue.

[former_member186851 · Accepted solution]

Hello Ramesh,

Then after Removecontexts  introduce a split By value at the end.

If its not working let us know.

[former_member190293 · Accepted solution]

Hi Ramesh!

Regards, Evgeniy.

[former_member186851 · Accepted solution]

Yes,Exactly the same.

The same I mentioned add Split by value at the end.

Thanks Eve for the screenshot.

[former_member190293 · Accepted solution]

Just to clarify your suggestion 🙂

Regards, Evgeniy.