Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
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?
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.