Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
can you replace & by and , and share a sample data to understand better and maybe propose something else
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? |