I have a job with a lot of data coming from 6 different files, i have several rules applied to this files so I can build the final output list to my database;
The last step of this process is hard. I need to get set a new Field that depends on a list of other fields.
My data is coming from a tMap and i need something like:
List<Material> list = the rows on tMap that have this "Material" key. Like a distinct clause on SQL.
Then, after doing the logic to create this new Field, i need to return all the values as a tMap;
Here is an example of it in pseudo-code
Class Material {
string key;
string value;
string status;
}
List<Material> list = tMap;
for each (key : list.distinct(Keys)){
value > 0 ? status = true : status = false;
}
return list.toTMap();
I have a tMap that maps my Material with several columns, we have a code, a price and a name, i.e.
Code = 1 ; Price = 10; Name = Plastic Fork; Code = 1 ; Price = 15; Name = Steel Fork; Code = 1 ; Price = 20; Name = Italian Fork; Code = 2 ; Price = 7; Name = Steel Knife;
Code = 2 ; Price = 10; Name = Ceramic Knife;
I want to return a list, grouping this materials by code;
List<Material> list = (Code =1, [Plastic Fork, Steel Fork, Italian Fork] ; Code=2, [Steel Knife, Ceramic Knife])
And then i want to consume this list on another tMap;
I've managed to create the grouped list using tJavaFlex. First i've created a class containing the information a i needed, the created a list of this class, looped through the tMap using the loop code to set my new Object and to add it to my list;
Then on the finish code, i've used lambda expressions to group it in a map of <MaterialCode, List<Material>> and print it, just to test it.
I want to consume this final Map in a tMap, is there any way?
