topic RE: Comparing Collections in Product Forum

Comparing Collections

aanchalm — Sat, 13 May 2023 05:14:00 GMT

Hi All,

I have two Collections :- Item Data and Final Data
In collection Item Data there is a column called Amount which can be for Ex- 575; Corresponding to this in Collection FInal Data i have a column called Amount which has two entries one positive and one negative i.e. 575 and -575.
i have to compare these two collections on the basis of this and write the Matching rows in a third collection with an Extra column "Result" in which i have to write Success and Failure. Also, Except amount we have only one column common to them and that is currency.

I have looping in mind but that will take time, any other approaches.Please find Attached the images for collections as well.

------------------------------
A S
------------------------------

RE: Comparing Collections

plnarayana777 — Sat, 13 May 2023 08:55:00 GMT

Hi

it will more helpful if you provide sample data in excel with expected output

you have mentioned to add one more column results

Regards
Lakshmi Narayana

------------------------------
Lakshmi Narayana
------------------------------

RE: Comparing Collections

aanchalm — Sat, 13 May 2023 10:51:00 GMT

The images are already attached

------------------------------
A S
------------------------------

RE: Comparing Collections

harish.mogulluri — Sat, 13 May 2023 15:19:00 GMT

Hi,
In general You can write c# or vb code to run faster if you have large no of rows in collection

I think 9 rows will not give much difference i believe. If you step out in the process it will be completed bit faster than usual step in the debug

------------------------------
-----------------------
If I answered your query. Please mark it as the "Best Answer"

Harish M
Lead developer
America/New_York TX
------------------------------

RE: Comparing Collections

harish.mogulluri — Sat, 13 May 2023 15:33:00 GMT

YOU can also use filter Action in utility collection manipulation and filter both equal and not equal condition int two different collection and add new column for each collection. and update either true or false based on the collection.
Once you completed the data manipulation you can merge two collection

Assuming NetAmount ( Text Data Item ) from Item Data coll is present

"[Amount]="&"'"&[NetAmount]&"'"

------------------------------
-----------------------
If I answered your query. Please mark it as the "Best Answer"

Harish M
Lead developer
America/New_York TX
------------------------------