I have a meta datset
I have another source dataset with
I wan the resultant dataset to be like this
How can we do this, what kind of join is going to help me do this in dataiku
The task you have is not really one of joining, but of stacking. I'm sure it can be solved with joins as well, but it will be made even more complex.
First, some definitions.
- Dataset containing TAG and tagname, let's call this tags.
- Dataset containing values, let's call values.
Now, for the actual steps.
1) Invert rows and columns in our tags dataset, this can be achieved with a Prepare recipe.
2) Use a Stack recipe to combine our Values and Tags_inverted datasets. It is very important for step 3 that Tags_inverted is selected first.
3) Finally, a prepare recipe to use the values in our first row (index 0) as new column names. The name of the processor is Use values of a row as column names.
The result will look as you've specified.