topic Re: how to build a small data dictionary in Talend Studio

how to build a small data dictionary

Andywang — Sat, 16 Nov 2024 00:03:28 GMT

I have two file:

A: two columns: the first column is text and second is values.

B: three columns:

the first column is text , the second is values, and the third one is text.

Aim: for each text in the column 1st from A and each value of 2nd from A, we would like to find that search these pari in the 1st and 2nd column in B and out put the corresponding text in 3rd column.

File A

CA 1

CB 2

....

File B

CA 1 Mike

CA 2 Jack

CA 3 Sara

CB 1 Ketty

CB 2 John

CB 3 Andy

.....

Like a example: we have CA and 1, we could return "Mike"

I know we could build a dictionary, however, which comment shall we used?

Thanks and best,

Xinhui

Re: how to build a small data dictionary

Anonymous — Tue, 15 Jun 2021 08:18:21 GMT

You just need to do an inner join? see this article:

https://community.talend.com/s/article/Doing-an-inner-join-using-a-tMap-component-i5Mrr

Re: how to build a small data dictionary

Andywang — Tue, 15 Jun 2021 21:37:15 GMT

thanks. It worked indeed.

Now I have a another table A as

names CA CB

p1 1 2

p2 2 3

.....

I would like find the all the corresponding text.

Like for p1, CA =1 CB=2， then we have: p1 on CA as Mike, on CB as John.

Is there a fast idea?

Thanks,

Best,

xinhui

Re: how to build a small data dictionary

Anonymous — Wed, 16 Jun 2021 03:11:14 GMT

Just select names, CA fields from table A, and then add a new column and set its value as "CA" , then do an inner join with File B to get the text.

Do the same thing for CB field, finally, merge the result based on names field if needed.

Regards

Shong

Re: how to build a small data dictionary

Andywang — Mon, 21 Jun 2021 12:26:37 GMT

sorry! really have no idea where to add new column and set as ""CA", you means add a new column at "metadata"?