How to determine if column has certain values
![eascott](https://us.v-cdn.net/6038231/uploads/Dataiku/nAvatar4.png)
I have 25 columns and I would like to arrange them so that if for example any of the 25 columns contains string 0d45, a new column LABELS will have the value SG or string 0f34 will have the value DS in the LABELS column. Is there a way to do this? Is it similar to concatenating columns in excel? I also have the labels column values stored in a worksheet. Would that be useful in this scenario?
Answers
-
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,598 Neuron
Welcome to the Dataiku community.
From your description, I’m not completely clear that I understand your use case.
That said I’m wondering if the visual recipe fold and unfold function might be of help to you. These are sort of like pivot and up pivot functions you might see elsewhere.If this clue does not help. I’d invite you to share a specific example of some sample data showing what the data looks like before and after the transformation you are trying to achieve.