How to get same account but different entries from queue?

Hi Everyone,

Scenario:-

I have an data in queue. Where account same but other details would be changed.

So, when this data get upload in queue (Orchestrator). This would show as two different transaction data. But I need data in one transaction item like:-

Account :- 123-456-098

Insert Date:- 2/28/2022

Make Name:- ABC
Make Name:-XYZ

ModelName:-M1
ModelName:-M2

YearNumber:-2000
YearNumber:-2012

Start Date:- 2/17/2019

Any one suggest? How to do this?

one strategy could be

  • group this data by Account
  • create csv string from groupmember data (JSON Serialization is creating String Overhead, but would also work)
  • store the CSV String on SpecificContent Dictionary

When processing the QueueItem

  • retrieve the CSV String from SpecificContent
  • pass it to generate DataTable and get back a data table

This data coming from sql and uploaded in queue. These two row having different transaction item.

But I don’t want to separate item.

vs

ok then please reformulate your requirement more clear in detail
exact input: ?
expected output: ?

Kindly note:

Above suggestion would result to 1 WorkQueueItem having reflected the information:

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.