Hello, I'm wondering if anyone can help a newbie. I have 3 entities with different attributes and I'd like to selectively copy those attribute values to a 4th (master) entity. Copying the 1st entity to the Master is easy with a Create Object action in a loop. Naturally, that doesn't work for the 2nd & 3rd entity because I want to map those attribute values to existing objects, not create new ones. I tried Change Object & Change List actions, but I can't figure out how to map entity 2 or 3 attributes values to the master. Both actions (Change Object & Change List) don't allow me to map entity 2 & 3 values to corresponding Master entity members. Both actions seem to restrict the Input Variable, Member & Value to the same entity defined as the Loop Iterator. I'm sure there's a way to do this. Please advise. Thanks.
Maybe I am over simplifying things, but this how I understand your problem:
If all 3 tables have the same amount of rows: Loop through Table 1 and:
Then Loop through Table 2 and
Then Loop through Table 3 and
When there are parent-child relations between the tables you create a loop within a loop withing a loop. Result will be a Table4 that looks like an "Excel sheet" which contains columns with duplicate data.
Hope that helps