How to delete a row in 2 dimensional Matrix

Solved1.88K viewsFormulas and Functions2D matrix formula modeler
0

Hello,
If I have a 2 dimensional matrix :
Qtr1   Product
Row1   Q1       Tesla
Row2   Q2        Ford
What command should I write to delete all the rows that have product “Ford” ?

Thanks

Selected answer as best
0

Thank you for the reply and for sharing the model. The script works.
Quick follow up question.
If I have to delete rows based on criteria in seperate column do I write the function twice example:
|M1::RowLst|.items.each {
if (|M1|.getSelection(it, |M1::Product|).value.equals(“Ford”))
it.delete()
}
|M1::RowLst|.items.each {
if (|M1|.getSelection(it, |M1::Qtr|).value.equals(“Q1”))
it.delete()
}

This does work but seems to be inefficient.

Answered question
You are viewing 1 out of 3 answers, click here to view all answers.