Filter from table in load editor

[Visualsetter]

I have a master table In my load editor that has 10 columns. 4 of those columns I want to group a call them Categories. Categories will be an additional column (making 11 total)

[steeefan]

Please specifiy what you actually mean by "4 of those columns I want to group a call them Categories". Ideally, show a screenshot of your anonymized data and the result you are hoping to get.

[anat]

something like below

load *,a&b as nwefield;

load a,b,c from table;