Hello,
I have a dataset that I am breaking it down to 5 different ones.
Each dataset has a common column, column_id.
When I am done preparing each dataset, I multi left join each prepared dataset back to the original based on column_id. I am doing that to bring back the prepared columns.
My problem is that a few of the prepared columns come back as completely null; however, if I perform a single join instead of the a multi join, the prepared columns come back with results.
I face this issue only when I am using a multi join.
Has anyone experienced something like this or might be of help?
Thanks!
P.S.
What I am doing is basically folding columns together, in order to create single collumns with the desired values. I used to be an Alteryx user and recently started using Dataiku. So, when I was using Alteryx to achieve the same result I would transpose my data and then join back the transposed columns to the original dataset.
Operating system used: Windows 11
