Jump to content
Sign in to follow this  

Compare two lists and copy values to anoter table

Recommended Posts

reynir    0



I am trying to compare two lists in my solution.  Detail description of my problem is in the attached document.


Short description of this problem is that in the table Production_Lot I have two lists, Prod_Measurement_List and Packaging_Measure_ToDo_List


The lists are generated from two portals containing Products_Measurements and Packaging_Measure_ToDo and the items in the lists are identical, like 9Docosahexaenoic acid (DHA)

8Eicosapentaenoic acid (EPA).


Then I have the test calculation checking if the patterncount of the product measurement from each portal record of the product_measurements is found in the list Packaging_Measure_ToDo_List and vice versa.


This test evaluates corectly if I compare the product_measurements with the Packaging_Measure_ToDo_list but if I compare the Packaging_Measure_ToDo with the Product_Measure_List then the calculation does not evaluate. Always showing null.


I hope you can undierstand my problem. And please ask if you need further clarifications.




Compare two lists and copy values to another portal.pdf

Share this post

Link to post
Share on other sites
Wim Decorte    455

Are you running those patterncounts in a script?  If so you can post the script?  Maybe the context is not correct for the 2nd test.

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

Sign in to follow this  


Important Information

By using this site, you agree to our Terms of Use.