how to delete rows from collection

#1
Hi,

I have requirement
  • Open xsl file and delete all rows where email address (in some column) contains “Val1” or “val2”.
  • I have used MS excel VBO to get in to collection and looped that collection and kept decision whether [clo.fieldname] = val1 or val2 using instring if the decision is true then deleting the rows from the collection else it its looping back again.
  • In this case if the column value is not having val1 or val2 i am connecting back to loop but here its always checking with 1st row its not looping.
  • Any body has idea how to resolve this?
 

VJR

Well-Known Member
Staff member
#3
In this case if the column value is not having val1 or val2 i am connecting back to loop but here its always checking with 1st row its not looping.
Here the 'No' branch of the Decision stage should point to the End Loop stage and not the Start Loop.
 

VJR

Well-Known Member
Staff member
#5
Hi BenKaba2,

- At first delete the blank row using Remove Empty Rows (or Remove Null Rows if necessary).
You can also use the Delete Row of Collection VBO (not Utility Collection) here.
- Now the row that says "Fund Name" will become the first row
- Now use 'Set Column Names From First Row'
 

VJR

Well-Known Member
Staff member
#8
From the error message it looks like the function can take 1 or 2 parameters but both need to be numbers. Market Price column may not be a Number data type and hence throwing an error.
 
#10
If you have a large number of rows in a collection, I will suggest you use a "Utility - Collection Manipulation > filter collection" action and filter based on the column name e.g column1 <> 'Val1' AND column2 <> 'Val2'. You don't need to put the column1 in square brackets e.g [column] <>'Val1'.
 

VJR

Well-Known Member
Staff member
#16
View attachment 2482
View attachment 2483

View attachment 2484

Hey
I am trying to get rid of the $ sign in the column in my collection, but some how it not possible for me to override the data back to the column without the $ sign. Anybody know why ?
The error is occurring because in the Store In field you have provided only the collection name. Supply it in the format [CollectionName.ColumnName].
But in any case even if you remove the $ sign, the Market Price column data type is still a Text and the RndUp seems to take a Number.
 
Top