I'm trying to filter or separate a few columns from the datasets so, is there a way in Experian we can separate columns?
There are 2 ways of doing this.
1.) You open your dataset, go to Explore, choose Columns from the top menu and now select columns you'd like to exclude. By hovering on the column an eye icon will show that let's you exclude columns and then also include them again. You can select various columns and just click one eye icon and all selected columns will be excluded. Check the results via the preview.
Excluded columns can be included again the same way.
2. In a Workflow use the Transform step and follow the same process