topic tMap multiple filtering conditions in Talend Studio

tMap multiple filtering conditions

Anonymous — Sat, 16 Nov 2024 13:21:32 GMT

My job contains a couple of inputs, tMap and a excel output. The input tables are Customers,Orders and OrderCateogry. The output columns are to be as follows
CustomerName|TotalOrders|OrdersforHDTV|OrdersforLaptop
How do I implement multiple filters within tMap or could you suggest a better way of accomplishing this.
Thanks

Re: tMap multiple filtering conditions

Anonymous — Mon, 12 Jul 2010 04:35:58 GMT

How do I implement multiple filters within tMap or could you suggest a better way of accomplishing this.

What are you expected situation? You can add multiple filters on tMap like this:
row1.name.equals("shong")&&row1.id>3
or
row1.name.equals("shong")||row1.id>3
Best regards
Shong

Re: tMap multiple filtering conditions

Anonymous — Mon, 12 Jul 2010 04:40:43 GMT

I would like 2 output columns filtered by different criteria on the same input column
One with
row1.name.equals("shong")
Other with
row1.name.equals("BI4better")

Re: tMap multiple filtering conditions

Anonymous — Mon, 12 Jul 2010 04:47:40 GMT

Hi
Can you give us an exmaple? What are the incoming record and output result?
Best regards
Shong

Re: tMap multiple filtering conditions

Anonymous — Mon, 12 Jul 2010 04:54:48 GMT

Let's say the input to tMap are Customers, Orders & OrderCategory.
OrderCategory would contain categories as Store and Online.
The output file needs to display the following
CustomerName| TotalNumberofOrders | NumberofStoreOrders | NumberofOnlineOrders
Thanks for your quick response

Re: tMap multiple filtering conditions

Anonymous — Mon, 12 Jul 2010 06:45:47 GMT

Hi
Just do some inner join on tMap between the three input tables. Can you give us a specific example? I will show you a demo job
Best regards
Shong

Re: tMap multiple filtering conditions

Anonymous — Mon, 26 Nov 2018 12:43:53 GMT

@shong

Can I give an example of mine and can yo give me a demo on how can I do it?