0

Need to save a value from one record and use it against all records

Michael Corrigan

January 07, 2015 17:34

None

Follow

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?

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Michael Corrigan January 15, 2015 17:24

  I figured out how to do this.  I did it by adding an expression after the initial Excel Source Data and I added a field to it called "JoinField".  I set the value of "JoinField" to always be 1, did separate filters and aggregations to portion the data out, and used the join field later on to join the data.