Data preparation

Hello,

Is there a way to have a node where the main data set (=dataset A) would be one input and the second (=dataset B) would be only with two columns (C and D).

Each time column X in dataset A contains a value from column C, this value would be replaced by the corresponding value in column D.

Thank you.

Bernard

Ps: Bonus question: is there a way to identify what records contain a many to many relationships within two specified columns?

Hello bluena,

the node you are looking for is the Cell Replacer and it does exactly what you are looking for.
Can you elaborate on your bonus question? I am not sure that I am getting it right.

Cheers,

1 Like

Awesome! Thanks!

For my bonus question: I would like to identify (or rather filter in a different flow) rows causing a many to many relationship between two columns that I specify.

Suppose a dataset with only 2 columns: â€śbooksâ€ť and â€śauthorsâ€ť:
Most of the time: a author writes one or many books. This is a one to many relationships.

There can a few books written by many authors.
Note: Iâ€™m assuming the case of a single book written by many authors has many records:
â€śBook Aâ€ť â€śAuthor Xâ€ť
â€śBook Aâ€ť â€śAuthor Yâ€ť
â€śBook Aâ€ť â€śAuthor Zâ€ť
Iâ€™m not assuming the following dataset:
â€śBook Aâ€ť â€śAuthor X, Author Y, Author Zâ€ť.

These 3 records cause a many to many relationship. How can I identify them?

Other similar question:

Is there a way to have a node where the main data set (=dataset X) would be two columns (A and B) and the second (=dataset Y) would also be with two columns (C and D).

Each time column A in dataset X contains a value from column C, column B would be replaced by the corresponding value of C in column D.

Use Group by with count by Book and Group by Author then filter in both groups records with counts greater then 1 and finally join filtered sets by Book and Author fields. The result will be your many to many.

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.