google-cloud-platformgoogle-cloud-datapreptrifacta

Cloud Dataprep - Replace code or id with value with middle dataset

I'm really new in GCP dataprep and now trying to create a recipe, but I can't figured out the way of doing it.

In summary I have 2 files, the first one with this columns: NAME, CONTRY_CODE, ...

And the second one with: COUNTRY_CODE, COUNTRY_NAME

How do I replace the COUNTRY_CODE from the first dataset with the COUNTRY_NAME of the second one (matching with the corresponding COUNTRY_CODE)?.

Thanks in advance!

Solution

  • For anyone trying to make this type of things. You can achieve it with the Lookup property in Dataprep!.

    Just select the column you want to change (in my case COUNTRY_CODE), then select Lookup -> Pick a Dataset (in my case the second one). And it will replace it as expected!