I'm developing a dataflow where I need to allocate the dollar amount from one record towards all the other records based on their percentage of the total. I can easily locate the dollar amount that I need using a filter or FLWOR transformation, but I can't figure out how to make that dollar amount visible to all the other records in order to allocate it. My thought was to add this dollar amount as a column to the original recordset and then do an expression to update all the records, but using the Join transformation woudln't allow me to do the type of Cross Join that would allow for this. Is there another approach I can take to make this value usable by the other records?
Need to save a value from one record and use it against all records