Ask Your Question

Revision history [back]

I'm finding any column that is a lookup_multi it only has 1 value in it. Does the new feed NOT do lookup_multi. These listings all should have data in the LFD_FeaturesInterior_15 but they don't. The LFD_FeaturesInterior_15 has values that match up with the old feed.

New Feed Value  New Feed Long Value Old Feed Value  Old Feed Long Value
373 Attic   06  Attic
374 Bar 10  Bar
375 Blinds  12  Blinds
377 Cedar Closet    16  Cedar Closet
378 Ceiling Fan 17  Ceiling Fan
379 Dining Area 21  Dining Area
380 Draperies   22  Draperies
381 Elevator    25  Elevator
390 Furnished   33  Furnished
391 Hearth  37  Hearth
393 Hot Tub 39  Hot Tub
397 Kitchen/Dining  44  Kitchen/Dining
398 Kitchen/Family  45  Kitchen/Family
399 Kitchen/Living  46  Kitchen/Living
400 Laundry Hook-ups    47  Laundry Hook-ups
401 Lead/Stain Glass    48  Lead/Stain Glass
406 Living/Dining   51  Living/Dining
409 Natural Woodwork    56  Natural Woodwork
410 Other   99  Other
412 Sauna   61  Sauna
415 Skylight    64  Skylight
417 Soaking Tub 86  Soaking Tub
421 Vaulted Ceiling 72  Vaulted Ceiling
422 Walk-in Closet  73  Walk-in Closet
423 Walk-in Pantry  74  Walk-in Pantry
424 Wet Bar 75  Wet Bar
425 Whirlpool Tub   76  Whirlpool Tub
427 Wood Stove Hook-up  78  Wood Stove Hook-up
428 Wood Stove Insert   79  Wood Stove Insert

Here is some data where the listings should have data.

Feed    LISTINGID   Raw converted
New Data    4005104 NULL    NULL
Old Data    4005104 01,02,05,06,12,13,14,16,17,20,21,24,27,28,36,43,44,46,47,48,49,51,53,56,57,65,67,73,76,80   1st Floor Laundry, 1st Floor Master BR, Alternative Heat Stove, Attic, Blinds, Cable, Cable Internet, Cedar Closet, Ceiling Fan, Den/Office, Dining Area, Eat-in Kitchen, Family Room, Fireplace-Gas, Handicap Modified, Island, Kitchen/Dining, Kitchen/Living, Laundry Hook-ups, Lead/Stain Glass, Library, Living/Dining, Master BR with BA, Natural Woodwork, Pantry, Smoke Det-Battery Powered, Smoke Det-Hdwired w/Batt, Walk-in Closet, Whirlpool Tub, 1 Fireplace
New Data    4155399 NULL    NULL
Old Data    4155399 01,06,15,17,20,21,23,27,37,43,50,52,54,56,58,65,73,77,83    1st Floor Laundry, Attic, Cathedral Ceilings, Ceiling Fan, Den/Office, Dining Area, DSL, Family Room, Hearth, Island, Living Room, Loft, Mudroom, Natural Woodwork, Playroom, Smoke Det-Battery Powered, Walk-in Closet, Wood Stove, 1 Stove
New Data    4247795 NULL    NULL
Old Data    4247795 01,02,06,10,11,14,15,17,18,20,24,26,27,30,31,32,35,37,39,43,44,50,52,53,54,55,57,59,61,62,66,69,70,72,73,75,76,82   1st Floor Laundry, 1st Floor Master BR, Attic, Bar, B-fast Nook/Room, Cable Internet, Cathedral Ceilings, Ceiling Fan, Central Vacuum, Den/Office, Eat-in Kitchen, Exercise Room, Family Room, Fireplace-Wood, Formal Dining Room, Foyer, Great Room, Hearth, Hot Tub, Island, Kitchen/Dining, Living Room, Loft, Master BR with BA, Mudroom, Multi Phonelines, Pantry, Recreation, Sauna, Sec Sys/Alarms, Smoke Det-Hardwired, Studio/Workshop, Sunroom, Vaulted Ceiling, Walk-in Closet, Wet Bar, Whirlpool Tub, 3
New Data    4349325 NULL    NULL
Old Data    4349325 01,02,04,06,09,11,13,14,15,17,20,21,22,24,27,31,32,40,43,44,50,53,54,55,56,57,58,64,65,69,70,72,73,74,76,77,80,83   1st Floor Laundry, 1st Floor Master BR, 2nd Kitchen, Attic, Balcony, B-fast Nook/Room, Cable, Cable Internet, Cathedral Ceilings, Ceiling Fan, Den/Office, Dining Area, Draperies, Eat-in Kitchen, Family Room, Formal Dining Room, Foyer, In Law Apartment, Island, Kitchen/Dining, Living Room, Master BR with BA, Mudroom, Multi Phonelines, Natural Woodwork, Pantry, Playroom, Skylight, Smoke Det-Battery Powered, Studio/Workshop, Sunroom, Vaulted Ceiling, Walk-in Closet, Walk-in Pantry, Whirlpool Tub, W
New Data    4350273 NULL    NULL
Old Data    4350273 06,08,10,17,20,34,39,44,47,50,56,65,72,73,77    Attic, Attic-Finished, Bar, Ceiling Fan, Den/Office, Gas Heat Stove, Hot Tub, Kitchen/Dining, Laundry Hook-ups, Living Room, Natural Woodwork, Smoke Det-Battery Powered, Vaulted Ceiling, Walk-in Closet, Wood Stove
New Data    4359144 NULL    NULL
Old Data    4359144 01,06,12,15,17,23,24,29,30,31,32,37,39,43,47,50,64,65,73,77,82  1st Floor Laundry, Attic, Blinds, Cathedral Ceilings, Ceiling Fan, DSL, Eat-in Kitchen, Fireplace-Screens/Equip., Fireplace-Wood, Formal Dining Room, Foyer, Hearth, Hot Tub, Island, Laundry Hook-ups, Living Room, Skylight, Smoke Det-Battery Powered, Walk-in Closet, Wood Stove, 3+ Fireplaces
New Data    4371149 NULL    NULL
Old Data    4371149 06,14,17,20,21,24,27,30,31,32,33,43,47,50,51,53,55,65,66,72,73,80,83    Attic, Cable Internet, Ceiling Fan, Den/Office, Dining Area, Eat-in Kitchen, Family Room, Fireplace-Wood, Formal Dining Room, Foyer, Furnished, Island, Laundry Hook-ups, Living Room, Living/Dining, Master BR with BA, Multi Phonelines, Smoke Det-Battery Powered, Smoke Det-Hardwired, Vaulted Ceiling, Walk-in Closet, 1 Fireplace, 1 Stove
New Data    4387183 NULL    NULL
Old Data    4387183 01,02,06,07,10,11,15,17,24,30,32,50,51,53,54,73,80  1st Floor Laundry, 1st Floor Master BR, Attic, Attic Fan, Bar, B-fast Nook/Room, Cathedral Ceilings, Ceiling Fan, Eat-in Kitchen, Fireplace-Wood, Foyer, Living Room, Living/Dining, Master BR with BA, Mudroom, Walk-in Closet, 1 Fireplace
New Data    4388952 NULL    NULL
Old Data    4388952 01,02,03,06,09,11,15,17,20,25,26,32,57,61,62,68,71,72,73,74,80,81   1st Floor Laundry, 1st Floor Master BR, 2nd Floor Laundry, Attic, Balcony, B-fast Nook/Room, Cathedral Ceilings, Ceiling Fan, Den/Office, Elevator, Exercise Room, Foyer, Pantry, Sauna, Sec Sys/Alarms, Sprinkler System, Theatre Room, Vaulted Ceiling, Walk-in Closet, Walk-in Pantry, 1 Fireplace, 2 Fireplaces
New Data    4393643 NULL    NULL
Old Data    4393643 01,04,06,11,15,17,20,24,27,30,31,32,37,43,47,50,53,59,64,72,73,76,80    1st Floor Laundry, 2nd Kitchen, Attic, B-fast Nook/Room, Cathedral Ceilings, Ceiling Fan, Den/Office, Eat-in Kitchen, Family Room, Fireplace-Wood, Formal Dining Room, Foyer, Hearth, Island, Laundry Hook-ups, Living Room, Master BR with BA, Recreation, Skylight, Vaulted Ceiling, Walk-in Closet, Whirlpool Tub, 1 Fireplace
New Data    4394889 NULL    NULL
Old Data    4394889 01,02,06,17,28,38,44,47,50,52,53,67,72,73,80,87 1st Floor Laundry, 1st Floor Master BR, Attic, Ceiling Fan, Fireplace-Gas, Home Warranty, Kitchen/Dining, Laundry Hook-ups, Living Room, Loft, Master BR with BA, Smoke Det-Hdwired w/Batt, Vaulted Ceiling, Walk-in Closet, 1 Fireplace
New Data    4403521 NULL    NULL
Old Data    4403521 01,06,07,09,11,15,16,17,24,30,31,37,41,43,44,47,50,53,54,62,66,70,72,73,82  1st Floor Laundry, Attic, Attic Fan, Balcony, B-fast Nook/Room, Cathedral Ceilings, Cedar Closet, Ceiling Fan, Eat-in Kitchen, Fireplace-Wood, Formal Dining Room, Hearth, In Law Suite, Island, Kitchen/Dining, Laundry Hook-ups, Living Room, Master BR with BA, Mudroom, Sec Sys/Alarms, Smoke Det-Hardwired, Sunroom, Vaulted Ceiling, Walk-in Closet, 3+ Fireplaces
New Data    4404232 NULL    NULL
Old Data    4404232 02,06,11,13,14,15,17,21,24,28,31,35,43,50,53,57,66,73,80    1st Floor Master BR, Attic, B-fast Nook/Room, Cable, Cable Internet, Cathedral Ceilings, Ceiling Fan, Dining Area, Eat-in Kitchen, Fireplace-Gas, Formal Dining Room, Great Room, Island, Living Room, Master BR with BA, Pantry, Smoke Det-Hardwired, Walk-in Closet, 1 Fireplace
New Data    4404316 NULL    NULL
Old Data    4404316 02,06,11,13,14,15,17,21,24,28,31,35,43,50,53,57,66,73,80    1st Floor Master BR, Attic, B-fast Nook/Room, Cable, Cable Internet, Cathedral Ceilings, Ceiling Fan, Dining Area, Eat-in Kitchen, Fireplace-Gas, Formal Dining Room, Great Room, Island, Living Room, Master BR with BA, Pantry, Smoke Det-Hardwired, Walk-in Closet, 1 Fireplace
New Data    4405285 NULL    NULL
Old Data    4405285 03,06,12,13,17,20,21,26,27,32,35,37,44,47,51,53,54,56,59,62,67,69,72,73,80,99   2nd Floor Laundry, Attic, Blinds, Cable, Ceiling Fan, Den/Office, Dining Area, Exercise Room, Family Room, Foyer, Great Room, Hearth, Kitchen/Dining, Laundry Hook-ups, Living/Dining, Master BR with BA, Mudroom, Natural Woodwork, Recreation, Sec Sys/Alarms, Smoke Det-Hdwired w/Batt, Studio/Workshop, Vaulted Ceiling, Walk-in Closet, 1 Fireplace, Other
New Data    4407204 NULL    NULL
Old Data    4407204 01,06,17,31,43,47,50,53,54,56,57,64,67,73,77    1st Floor Laundry, Attic, Ceiling Fan, Formal Dining Room, Island, Laundry Hook-ups, Living Room, Master BR with BA, Mudroom, Natural Woodwork, Pantry, Skylight, Smoke Det-Hdwired w/Batt, Walk-in Closet, Wood Stove
New Data    4408400 NULL    NULL
Old Data    4408400 01,06,09,10,13,14,15,17,20,21,26,27,29,30,32,43,44,49,50,53,54,56,57,62,66,69,72,73,74,82   1st Floor Laundry, Attic, Balcony, Bar, Cable, Cable Internet, Cathedral Ceilings, Ceiling Fan, Den/Office, Dining Area, Exercise Room, Family Room, Fireplace-Screens/Equip., Fireplace-Wood, Foyer, Island, Kitchen/Dining, Library, Living Room, Master BR with BA, Mudroom, Natural Woodwork, Pantry, Sec Sys/Alarms, Smoke Det-Hardwired, Studio/Workshop, Vaulted Ceiling, Walk-in Closet, Walk-in Pantry, 3+ Fireplaces
New Data    4411601 NULL    NULL
Old Data    4411601 03,06,14,15,17,20,21,24,27,28,31,32,43,47,50,53,54,66,73,76,81,87   2nd Floor Laundry, Attic, Cable Internet, Cathedral Ceilings, Ceiling Fan, Den/Office, Dining Area, Eat-in Kitchen, Family Room, Fireplace-Gas, Formal Dining Room, Foyer, Island, Laundry Hook-ups, Living Room, Master BR with BA, Mudroom, Smoke Det-Hardwired, Walk-in Closet, Whirlpool Tub, 2 Fireplaces
New Data    4419691 NULL    NULL
Old Data    4419691 03,06,09,13,14,17,18,20,21,22,24,27,30,37,43,44,46,47,53,54,55,62,64,73,76,77,80    2nd Floor Laundry, Attic, Balcony, Cable, Cable Internet, Ceiling Fan, Central Vacuum, Den/Office, Dining Area, Draperies, Eat-in Kitchen, Family Room, Fireplace-Wood, Hearth, Island, Kitchen/Dining, Kitchen/Living, Laundry Hook-ups, Master BR with BA, Mudroom, Multi Phonelines, Sec Sys/Alarms, Skylight, Walk-in Closet, Whirlpool Tub, Wood Stove, 1 Fireplace
New Data    4423024 NULL    NULL
Old Data    4423024 01,02,06,11,13,17,20,21,24,25,31,35,36,37,42,43,44,47,50,53,54,56,57,62,66,69,73,74,77,82   1st Floor Laundry, 1st Floor Master BR, Attic, B-fast Nook/Room, Cable, Ceiling Fan, Den/Office, Dining Area, Eat-in Kitchen, Elevator, Formal Dining Room, Great Room, Handicap Modified, Hearth, Intercom, Island, Kitchen/Dining, Laundry Hook-ups, Living Room, Master BR with BA, Mudroom, Natural Woodwork, Pantry, Sec Sys/Alarms, Smoke Det-Hardwired, Studio/Workshop, Walk-in Closet, Walk-in Pantry, Wood Stove, 3+ Fireplaces