Compare/Count a field in a datapil to other records in the same datapil without looping?

[johnw]

I have an Epicor BAQ report I use in Workato that gives me a list of all SKUs in an order and their shipping information

99.9% of the time all the SKUs in an order will be on the same pricebook but on rare occasions 2 SKUs might on pricebook X and 1 SKU on pricebook Y so each record in the BAQ report will have a pricebook field 

is there a way in workato to count the number of different prciebooks or do i have to loop through each record to count them?

thanks

[gary1 · Accepted solution]

I don't know how your data is structured, but you can use a combination of pluck and uniq to accomplish what you need.

Here's how they work:

list = [
    {"book": "a"},
    {"book": "a"},
    {"book": "b"}
]

books = list.pluck("book") 
## outputs ["a","a","b"]

uniqbooks = list.pluck("book").uniq 
## outputs ["a","b"]

uniqbooks.size 
## outputs 2, the number of items in the array

[johnw]

this is working great but now I'm curios if there is a way to see if there are any blanks

if I do this and test   [Value Step3}.pluck('PriceLstParts_SfPriceBookEntryId18Char_c')

I get a list of tehse fields such as

"A" "B" "C" 

but sometimes its "A" "B"  "" "C" 

where one is blank I just want tos ee if Blanks are greater than 0

played around with scan and blank etc can't seem to get it to work

[Value Step3}.pluck('PriceLstParts_SfPriceBookEntryId18Char_c').blank?

[gary1]

It's not published in Workato, but "count" is a standard Ruby method that you can use.

@meghan-legaspi Could someone add "count" to the formula helper and also to the Ruby docs? 

https://docs.workato.com/developing-connectors/sdk/sdk-reference/ruby_methods.html 

[meghan-legaspi]

Hey @gary1 – great thought! I can pass this along, though I also recommend submitting that feedback through the portal. Our team loves to keep in touch with the folks that make these requests to let them know when it's done! 🙂

[gary1]

Is the portal the one where users have to vote on which requests get prioritized?

[meghan-legaspi]

Hey Gary,

You can submit feedback via AssistIQ when you are logged into your Workato account (see screenshot below). This should go straight to our support team – user voting shouldn't affect that.