Categorical columns get distorted after using recipes like join, pivot, or group
Categorical columns get distorted after using recipes like join, pivot, or group, even with clean data and unique IDs. Anyone else facing this?
Operating system used: Windows
Answers
-
Hi,
I hope that you are doing well. Would you mind clarifying what you mean by "columns get distorted"?
Best,
Yasmine
-
Hi, thanks for replying! I am new to Dataiku. The column I am having trouble with is "TAMANO" (meaning "size"). When I apply the pivot recipe, I lose all the data in the column. The other columns are ok.
-
tgb417 Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS ML Practitioner, Dataiku DSS Core Concepts, Neuron 2020, Neuron, Registered, Dataiku Frontrunner Awards 2021 Finalist, Neuron 2021, Neuron 2022, Frontrunner 2022 Finalist, Frontrunner 2022 Winner, Dataiku Frontrunner Awards 2021 Participant, Frontrunner 2022 Participant, Neuron 2023 Posts: 1,626 NeuronThere seems to be quite a difference between image 1 and 2 above. These changes on first glance appear to be more than a pivot recipe. Can you say more about the flow between these two images. Can you also share the screens of the pivot recipe that shows the pivot setup and aggregations. That might help the community to better help you.