How to delete a row in 2 dimensional Matrix

Solved2.11K 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

Answered question
1

Hi all.
Shrishank, this is the simple A-script that solves your problem. It need to remember that A-script will not remove Rows if all rows contain only ‘Ford’ in the Product field. The reason for this: any category in QM must have at least one Item.

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