Navigation: How do I? >
Handle datasets with many columns
Easy Data Transform can help you to easily remove or rename columns in datasets with large numbers of columns.
If your dataset has a large number of empty columns you can remove them by checking ignore empty columns when you input it.
To quickly remove a large number of columns using the Remove Cols transform, you can do it by filtering column names. For example, to remove the columns with name that contain "id":
•Add a Remove Cols transform.
•Type id into the filter field. All the columns whose names contain "id" should now be visible (not case sensitive).
•Click the Unselect all button.
•Click the Clear button.
All the columns whose names contain "id" should now be removed by the transform. You can repeat this process as often as needed.
To quickly rename a large number of columns using the Rename Cols transform, you can do it using Replace text:
•Add a Rename Cols transform.
•Click the Replace text button.
•Enter the text you want to Replace and the text you want to replace it With. You can match as Text, Exact text or Regex, with case sensitive matching optional.
•Click Apply to make the change.