To populate Multiple IDs for UNIQUE Vehicle
Moderators: chulett, rschirm, roy
Hi kumar_s,
SOURCE.trim(source field)=TRIM.code Here TRIM is lookup table.
Here i am pasting lookup & Source data
Lookup Table
select * from raoridbf.trim
TRIM_ID CODE DESCRIPTION
----------- ---------------------------------
300 TOURING TOURING
301 PREMIUM PREMIUM
302 BASE BASE
303 Model equals Series Name
304 T T
305 W/NAVIGATION NAVIGATION
306 TYPE-S TYPE-S
307 TYPE-S W/NAVIGATION TYPE-S
W/NAVIGATION
308 BASE W/NAVIGATION BASE
W/NAVIGATION
309 BASE W/NAVIGATION BASE
W/NAVIGATION
310 EAGLE EAGLE
311 Unknown Unknown trim or multiple
trim
312 VANTAGE VANTAGE
313 DBARI DBARI
314 VANTAGE GT VANTAGE GT
316 AVNT QUATTRO AWD AVNT QUATTRO
AWD
Source(staging)
select TRIM from raoridbf.STG_VIP_INV
TRIM ------------------------------------------------------------------------------
/PREMIUM/BASE/SPORT/SPORT-PREMIUM/ TOURING /PREMIUM/BASE/SPORT/SPORT-PREMIUM/ BASE M AWD LX/EX -/LT/LS/ /LIMITED W/LEATHER/LIMITED/ LX SE /LAREDO/COLUMBIA/FREEDOM EDITION/SPECIAL EDITION/ROCKY MOUNTAIN/SE W/T PKG/ EX LIMITED /GT DELUXE/GT PREMIUM/ /3LT/2LT/1LT/ /DENALI/SLT/SLE/ /PREMIUM/BASE/SPORT/ LAR/COL/FR 3.2 /XLS SPORT/XLS/ /PREMIUM/BASE/ /XL/XLT/STX/ /SR5/SR5 SPORT/SR5 W/LEATHER/ /HARLEY-DAVIDSON/LARIAT/XL/XLT/LARIAT LE/XLT SPORT/ /BASE/COMMEMORATIVE EDITION/ /SPORT/RHD/ /BASE/LS/ SPORT /BASE/LT/Z71/LS/WORK TRUCK/ /TREMOR/XL/XLT/EDGE/ /XL/XLT/STX/ XR7 /1500 BASE/1500 Z66 PREMIUM/ /TOURING/LIMITED/ /LARAMIE/LARAMIE SPORT/ST/SLT SPORT/SLT/ /SPORT/SXT/ /BASE/COMMEMORATIVE EDITION/ /3.5 SE DRIVER PREFERRED/3.5 SL DRIVER PREFERRED/3.5 SE PREMIUM AUDIO PKG/3.5 SE/3.5 SE ELITE/3.5 SL/3.5 SL ELITE/3.5 SE SENSORY/ LS /XL/TOURING/LIMITED/XLS/ /PRERUNNER SR5/PRERUNNER/X-RUNNER/X-RUNNER TRD OFF-ROAD V6/X-RUNNER TRD SPORT V6/PRERUNNER TRD OFF-ROAD/PRERUNNER TRD SPORT V6/ /LT/Z71/LS/WORK TRUCK/ /HARLEY-DAVIDSON/LARIAT/XL/XLT/
Regards,
iamnagus
SOURCE.trim(source field)=TRIM.code Here TRIM is lookup table.
Here i am pasting lookup & Source data
Lookup Table
select * from raoridbf.trim
TRIM_ID CODE DESCRIPTION
----------- ---------------------------------
300 TOURING TOURING
301 PREMIUM PREMIUM
302 BASE BASE
303 Model equals Series Name
304 T T
305 W/NAVIGATION NAVIGATION
306 TYPE-S TYPE-S
307 TYPE-S W/NAVIGATION TYPE-S
W/NAVIGATION
308 BASE W/NAVIGATION BASE
W/NAVIGATION
309 BASE W/NAVIGATION BASE
W/NAVIGATION
310 EAGLE EAGLE
311 Unknown Unknown trim or multiple
trim
312 VANTAGE VANTAGE
313 DBARI DBARI
314 VANTAGE GT VANTAGE GT
316 AVNT QUATTRO AWD AVNT QUATTRO
AWD
Source(staging)
select TRIM from raoridbf.STG_VIP_INV
TRIM ------------------------------------------------------------------------------
/PREMIUM/BASE/SPORT/SPORT-PREMIUM/ TOURING /PREMIUM/BASE/SPORT/SPORT-PREMIUM/ BASE M AWD LX/EX -/LT/LS/ /LIMITED W/LEATHER/LIMITED/ LX SE /LAREDO/COLUMBIA/FREEDOM EDITION/SPECIAL EDITION/ROCKY MOUNTAIN/SE W/T PKG/ EX LIMITED /GT DELUXE/GT PREMIUM/ /3LT/2LT/1LT/ /DENALI/SLT/SLE/ /PREMIUM/BASE/SPORT/ LAR/COL/FR 3.2 /XLS SPORT/XLS/ /PREMIUM/BASE/ /XL/XLT/STX/ /SR5/SR5 SPORT/SR5 W/LEATHER/ /HARLEY-DAVIDSON/LARIAT/XL/XLT/LARIAT LE/XLT SPORT/ /BASE/COMMEMORATIVE EDITION/ /SPORT/RHD/ /BASE/LS/ SPORT /BASE/LT/Z71/LS/WORK TRUCK/ /TREMOR/XL/XLT/EDGE/ /XL/XLT/STX/ XR7 /1500 BASE/1500 Z66 PREMIUM/ /TOURING/LIMITED/ /LARAMIE/LARAMIE SPORT/ST/SLT SPORT/SLT/ /SPORT/SXT/ /BASE/COMMEMORATIVE EDITION/ /3.5 SE DRIVER PREFERRED/3.5 SL DRIVER PREFERRED/3.5 SE PREMIUM AUDIO PKG/3.5 SE/3.5 SE ELITE/3.5 SL/3.5 SL ELITE/3.5 SE SENSORY/ LS /XL/TOURING/LIMITED/XLS/ /PRERUNNER SR5/PRERUNNER/X-RUNNER/X-RUNNER TRD OFF-ROAD V6/X-RUNNER TRD SPORT V6/PRERUNNER TRD OFF-ROAD/PRERUNNER TRD SPORT V6/ /LT/Z71/LS/WORK TRUCK/ /HARLEY-DAVIDSON/LARIAT/XL/XLT/
Regards,
iamnagus
Hi Here i am sending the SOURCE data once again as earlier one is getting a bit confusing
select TRIM from raoridbf.STG_VIP_INV
TRIM
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
/PREMIUM/BASE/SPORT/SPORT- PREMIUM/
TOURING
/PREMIUM/BASE/SPORT/SPORT-PREMIUM/
BASE
M AWD
LX/EX
-
/LT/LS/
/LIMITED W/LEATHER/LIMITED/
LX
SE
/LAREDO/COLUMBIA/FREEDOM EDITION/SPECIAL EDITION/ROCKY MOUNTAIN/SE W/T PKG/
EX
LIMITED
/GT DELUXE/GT PREMIUM/
/3LT/2LT/1LT/
/DENALI/SLT/SLE/
/PREMIUM/BASE/SPORT/
LAR/COL/FR
3.2
/XLS SPORT/XLS/
/PREMIUM/BASE/
/XL/XLT/STX/
/SR5/SR5 SPORT/SR5 W/LEATHER/
/HARLEY-DAVIDSON/LARIAT/XL/XLT/LARIAT LE/XLT SPORT/
/BASE/COMMEMORATIVE EDITION/
/SPORT/RHD/
/BASE/LS/
SPORT
/BASE/LT/Z71/LS/WORK TRUCK/
/TREMOR/XL/XLT/EDGE/
/XL/XLT/STX/
XR7
/1500 BASE/1500 Z66 PREMIUM/
/TOURING/LIMITED/
/LARAMIE/LARAMIE SPORT/ST/SLT SPORT/SLT/
/SPORT/SXT/
/BASE/COMMEMORATIVE EDITION/
/3.5 SE DRIVER PREFERRED/3.5 SL DRIVER PREFERRED/3.5 SE PREMIUM AUDIO PKG/3.5 SE/3.5 SE ELITE/3.5 SL/3.5 SL ELITE/3.5 SE SENSORY/
LS
/XL/TOURING/LIMITED/XLS/
/PRERUNNER SR5/PRERUNNER/X-RUNNER/X-RUNNER TRD OFF-ROAD V6/X-RUNNER TRD SPORT V6/PRERUNNER TRD OFF-ROAD/PRERUNNER TRD SPORT V6/
/LT/Z71/LS/WORK TRUCK/
/HARLEY-DAVIDSON/LARIAT/XL/XLT/
select TRIM from raoridbf.STG_VIP_INV
TRIM
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
/PREMIUM/BASE/SPORT/SPORT- PREMIUM/
TOURING
/PREMIUM/BASE/SPORT/SPORT-PREMIUM/
BASE
M AWD
LX/EX
-
/LT/LS/
/LIMITED W/LEATHER/LIMITED/
LX
SE
/LAREDO/COLUMBIA/FREEDOM EDITION/SPECIAL EDITION/ROCKY MOUNTAIN/SE W/T PKG/
EX
LIMITED
/GT DELUXE/GT PREMIUM/
/3LT/2LT/1LT/
/DENALI/SLT/SLE/
/PREMIUM/BASE/SPORT/
LAR/COL/FR
3.2
/XLS SPORT/XLS/
/PREMIUM/BASE/
/XL/XLT/STX/
/SR5/SR5 SPORT/SR5 W/LEATHER/
/HARLEY-DAVIDSON/LARIAT/XL/XLT/LARIAT LE/XLT SPORT/
/BASE/COMMEMORATIVE EDITION/
/SPORT/RHD/
/BASE/LS/
SPORT
/BASE/LT/Z71/LS/WORK TRUCK/
/TREMOR/XL/XLT/EDGE/
/XL/XLT/STX/
XR7
/1500 BASE/1500 Z66 PREMIUM/
/TOURING/LIMITED/
/LARAMIE/LARAMIE SPORT/ST/SLT SPORT/SLT/
/SPORT/SXT/
/BASE/COMMEMORATIVE EDITION/
/3.5 SE DRIVER PREFERRED/3.5 SL DRIVER PREFERRED/3.5 SE PREMIUM AUDIO PKG/3.5 SE/3.5 SE ELITE/3.5 SL/3.5 SL ELITE/3.5 SE SENSORY/
LS
/XL/TOURING/LIMITED/XLS/
/PRERUNNER SR5/PRERUNNER/X-RUNNER/X-RUNNER TRD OFF-ROAD V6/X-RUNNER TRD SPORT V6/PRERUNNER TRD OFF-ROAD/PRERUNNER TRD SPORT V6/
/LT/Z71/LS/WORK TRUCK/
/HARLEY-DAVIDSON/LARIAT/XL/XLT/
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: