topic Re: tUniquerow problem in Talend Studio

tUniquerow problem

Anonymous — Tue, 23 May 2017 10:16:53 GMT

Ciao,

Ho un problema con il componente uniquerow.

Ho questi file:

Per primo:

WBS | PN | Stato

111 | 222 | S

111 | 222 | Q

In secondo:

WBS | PN | Quantità

111 | 222 | 1

Volevo usare fila tunique per fare un join con l'unico.

Infatti ho:

WBS | PN | Stato | Quantità

111 | 222 | S | 1

111 | 222 | Q |

Poi voglio filtrare le righe con lo status di Q e di fare aderire con duplicato. Ma questo con tunique non è possibile.

chi può aiutarmi?

Re: tUniquerow problem

Anonymous — Tue, 23 May 2017 10:43:53 GMT

Hi,

how do you link first and second table?

What is the join criteria?

I don't see anything to get them linked.

Cheers!

Re: tUniquerow problem

Anonymous — Tue, 23 May 2017 10:44:08 GMT

Hi,

how do you link first and second table?

What is the join criteria?

I don't see anything to get them linked.

Cheers!

Re: tUniquerow problem

cterenzi — Tue, 23 May 2017 14:34:04 GMT

You can use tUniqRow to make your quantity values unique by specifying WBS and PN as the key attributes.

If you only want to join quantities to "S" records, you can add a column to the quantity flow with a static value of "S" using a tMap. Then you can join quantities to the state records using another tMap, left outer join on WBS, PN and State.