Creating a new dimension from a dimension or field

[andre_avenant]

So how do i create a new dimension in the load script from lets say the following scenario:

LOAD
[transport_type] ,
[season],
[supplier],

but what i want is to create a new filed called say TRUCKTYPE on the following criteria:

the transport must be Road, the Season must be winter and supplier must be Ford and that I want to call Ford Truck,

then the transport must be Road, Season must be winter and supplier must be VW and that will be called VW Truck?

Basically creating a dimension based on certain current fields data

Regards

[Taoufiq_Zarra]

several ways of doing it, if it's not a complicated calculation, I propose : if(Match(transport_type,'Road') and Match(season,'winter')and Match(supplier,'Ford'),'Ford Truck', if(Match(transport_type,'Road')and Match(season,'winter') and Match(supplier,'VW'),'VW Truck')) as TRUCKTYPE

[andre_avenant]

Granted but what happens if you say for example what you gave and then the transport type must be road and gravel or you don't want gravel in the selection. But you don't want list the other transports type each individually?:
if(Match(transport_type,'Road')&Match(season,'winter')&Match(supplier,'Ford'),'Ford Truck',
if(Match(transport_type,'Road')&Match(season,'winter')&Match(supplier,'VW'),'VW Truck')) as TRUCKTYPE,

[Taoufiq_Zarra]

can you replace & by and , and share a sample data to understand better and maybe propose something else

[andre_avenant]

Transport type	season	supplier	miles
road	winter	VW	200
sea	summer	Ford	100
snow	autum	Toyota	200
gravel	spring	Audi	200
air	winter	VW	300
road	winter	Ford	444
sea	autum	Toyota	555
road	summer	Audi	222
sea	summer	Toyota	1445
road	summer	Audi	60
sea	summer	Toyota	50
road	summer	VW	40
sea	summer	VW	50
snow	summer	Ford	1
gravel	summer	Toyota	20
air	winter	Audi	2
so I want to create a new dimension from this and lets call it Transport
The criteria for transport is the following,
if(supplier=VW & AUDI and the season =summer,german, if(supplier=VW & Ford and season = winter, Southafrica
But now if want to take these same if statements and just exclude vw,Audi,Ford without typing out the other brand how do you do it?