To populate Multiple IDs for UNIQUE Vehicle

[kumar_s]

I could not get the requirement clearly. Is TRIM you lookup data. You can use the pictorial representation if required. Will the Trim.code have 'XLT' as data?

[chulett]

Do you know the maximum number of values you could receive in one string? Your example shows 8 for example.

[iamnagus]

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

[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/

[ray.wurlod]

I don't see any TRIM_ID in your source.

[chulett]

Or an answer to my rather simple question.