tUniquerow problem

Four Stars

tUniquerow problem

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

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?

 

 

Seven Stars

Re: tUniquerow problem

Hi,

 

how do you link first and second table?

What is the join criteria?

I don't see anything to get them linked.

 

Cheers!

Seven Stars

Re: tUniquerow problem

Hi,

 

how do you link first and second table?

What is the join criteria?

I don't see anything to get them linked.

 

Cheers!

Tags (1)
Ten Stars

Re: tUniquerow problem

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.

15TH OCTOBER, COUNTY HALL, LONDON

Join us at the Community Lounge.

Register Now

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download