In a next version of TOS, we will have only one component with multiple outputs: tReplicate. tMap will also be able to output several distinct rows (but tMap is a very special component).
Hi,
I am trying to use this in my value replacement issue. I need to count at several levels and then put it all together.
How should I do this?
The only conents that the flow into more then one component are the input ones...
I was also trying to feed a tMap and tAggregateRow into a tmap to use the counts but I couldn't do this either...
Any suggestions would be greatly appreciated!
Many Thanks,
Jay
881
What I need to do is left outer join two text files to the main database table. After sorting the dataset if there are more then 10 records in a group I need to count how many records match each of text files. If the largest replacement is enough to reduce the group count to <=10 then move on otherwise repeat the step for the second largest replacement count.
Re-sort the dataset then if any groups still have a count greater then 10 change everything past 10 to "Other".
Hi,
To accomplish this I think I need the "intra-group" ranking function for the "Other" peice.
As for the first steps what should I do is maybe:
If (Max($agg1 > 10) {
If ($agg2 > $agg2) {
$firstReplace = $agg1 - $agg2 }
Else {
$firstReplace = $agg1 - $agg2 }
If ($firstReplace < 10) {
#do the first replace only }
Else {
If ($agg2 < $agg2) {
$secondReplace = $firstReplace - $agg2 }
Else {
$secondReplace = $firstReplace - $agg2 }
#do the first and second replacments
If ($secondReplace > 10) {
If ($ranking > 10) {
#replace all ranks > 10 with 'Other' }
}
Else {
#do no replacements }
Attached is an image of the type of workflow operation I would like to do with this multiple input/output questions...
Does that make any sense? Any help would be greatly appreciated. Please ask about anything that I didn't explain properly in the above.
Many Thanks,
Jay
Jay, what you want to do seems a bit "complicated" to me. In addition to the description of your job, we also need some data example (input and output).
