Five Stars

tMap instead of tReplicate + tFilterRow?

I have some table rows which I'm sorting into a series of tables based on the contents of a column (location).

 

My brute force method (which works) is to use tReplicate, then a separate duplicate Main threads to tFilterRow. After seeing that tMap has the ability to create multiple output flows, I've been digging through documentation to see if that could be used to output multiple filtered output flows. Is this possible?

 

EDIT: Sample Table - Goal is to output the location A lines to one output stream, location B to one, location C to another.

 

|=-------+--------+-------=|
|Location|Name    |Quantity|
|=-------+--------+-------=|
|A       |Johnson |5       |
|A       |Jackson |12      |
|B       |Johnson |23      |
|B       |Jackson |2       |
|C       |Williams|33      |
|C       |Johnson |23      |
|C       |Jackson |8       |
'--------+--------+--------'
2 ACCEPTED SOLUTIONS

Accepted Solutions
Ten Stars

Re: tMap instead of tReplicate + tFilterRow?

each input and output flow have filter tools

You can combine conditions by && or || as many as You need

 

Screen Shot 2017-05-31 at 9.28.00 PM.png

-----------
Five Stars

Re: tMap instead of tReplicate + tFilterRow?

Found what I was looking for in the retired forum thread: If Statement: tMap Expression Builder

 

 In the example table (which I added to the original post), the tMap would look like this:

 

tMap - Multiple Output Filters.png

5 REPLIES
Ten Stars

Re: tMap instead of tReplicate + tFilterRow?

Hi,

 

yes, of course - it possible

I prefer tMap as well because it allow not only split/filter flows, but at same time make transformations 

what better - always depends from current task

 

Screen Shot 2017-05-31 at 8.17.42 PM.png

-----------
Five Stars

Re: tMap instead of tReplicate + tFilterRow?

Great! How do you set up multiple filters?

Ten Stars

Re: tMap instead of tReplicate + tFilterRow?

each input and output flow have filter tools

You can combine conditions by && or || as many as You need

 

Screen Shot 2017-05-31 at 9.28.00 PM.png

-----------
Five Stars

Re: tMap instead of tReplicate + tFilterRow?

Found what I was looking for in the retired forum thread: If Statement: tMap Expression Builder

 

 In the example table (which I added to the original post), the tMap would look like this:

 

tMap - Multiple Output Filters.png

Five Stars

Re: tMap instead of tReplicate + tFilterRow?

You must have posted while I was typing my findings. Thanks for your help!