Delete Rows in Collection

[danniaus1]

Hi Guys,

To explain to you my process

I have an email that comes through with a spreadsheet attached

The spreadsheet that comes through is dynamic, the worksheet tabs can be called different things and the cell locations differ.

I want to extract only certain information but don't know where that information will be each time

This is the top of the collection

View attachment 1560334393754.png

Then this is some data further down

View attachment 1560334237728.png

I want to extract the data highlighted in yellow and the data hidden in red.

View attachment 1560385523025.png

 

[Sukesh Kumaru]

Hello,

It's simple.

Looping the collection which was shown in above attachment(View attachment 1560334393754.png)
Search for the <Collection name>.Energy Specification="Total :" if it is True, then read/extract the entire row to other Data items and process according to your requirement.

Happy to Help !
Good Luck !

 

[danniaus1]

Thankyou, sorry for the silly question but how do I read/extract the entire row??

Thanks in advance

Hello,

It's simple.

Looping the collection which was shown in above attachment(View attachment 1560334393754.png)
Search for the <Collection name>.Energy Specification="Total :" if it is True, then read/extract the entire row to other Data items and process according to your requirement.

Happy to Help !
Good Luck !

 

[Sukesh Kumaru]

Hello,

Just use the
<collection name. Column name>=<data item name> to pass the values.

Happy to Help !
Good Luck !

 

[danniaus1]

Hello,

Just use the
<collection name. Column name>=<data item name> to pass the values.

Happy to Help !
Good Luck !

Hi Sukesh

What if the column names are dynamic so I do not know what they will be each time?

Thanks

 

[Sukesh Kumaru]

Hi Sukesh

What if the column names are dynamic so I do not know what they will be each time?

Thanks

Hello,

BO: Utility-Collection Manipulation
Action: Get Collection Fields

This action may help you to fetch all the column names,
all the column names and data types are copied to other collection and you can find using search keywords.

Happy to Help !
Good Luck !

 

[democko_kamil]

If the header is always the same..

I would use Filter Collection, that would look something like
View attachment 1560779365297.png

that would extract one row (which has value "Total"), from which i might be able to extract values i need.

I'm not sure this would help your case.

 

[Rash23]

Hi, I want to delete top row of collection or excel, basically collection is formed on same excel sheet, Top row just has data in A1 cell and all the other columns are blank, please suggest how to delete top row of excel using BP.