I am an analyst in Datameer and my role is to cleanse the data for further analysts to work on.
We have a data set which a column consists of an array of attributes - applicable to an entity of a device (machine)
I've attempted the "Split Column" functionality.
The challenge is the same attribute - for example - "workstation"; will go into separate columns.
My goal is to enable the unique attributes to be the column header so a single column would only return the same attribute.
Do you have any tips and tricks to offer me in cleaning this column in a "structured" way please?
Please sign in to leave a comment.