Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Unexpected results form Merge Function

  1. #1
    Board Regular
    Join Date
    Aug 2005
    Posts
    534
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Unexpected results form Merge Function

    I am getting strange results form the Merge Function.

    I am Merging some data form a spreadsheet that has 21 rows
    (second sheet) of data yet after the merge in has populated 44 rows with data (first sheet). the 21 rows are correct but 23 addition rows have the same data and I have no idea why they have been slected

    See below

    Just noted that it must be something to do with EG308 it does not seem to like it as it missing form the results and the removal reason "Site Burnt down, awaiting rebuild" has been populated in all the spurious lines.

    Spreadsheet with 21 rows data being merged Removal Reason

    Excel 2010
    CDEFG
    1
    2Venue CodeVenue TypeStatusNameREMOVAL REASON
    3EG308ForecourtN/AGowy S/Stn Site burnt down, awaiting rebuild
    412926ForecourtLiveBrands Hill ConnectRefit until 21st December
    5347853ForecourtLiveShell Darby`S Corner (730)Closed for refit - reinstall November 2011
    6308301ForecourtLiveShell Fontwell (080)Closed for refit - issue with new shop format, unknown reopening
    7302379ForecourtLiveShell Bromley (349)Refit, reopening date unknown
    8349021ForecourtLiveShell Downend (386)Closed for refit - reinstall December 2011
    9398097ForecourtLiveShell Carlisle North (700)Closed for refit - reinstall December 2011
    10308245ForecourtN/AShell Allstop (066)Closed for refit - reinstall December 2011
    11380685ForecourtN/AShell Abbeymount (074)Permanent closure
    126302ForecourtLiveKilmarnock Removed, site closed
    13358212ForecourtLiveShell Fazakerley (494)Closed for refit - reinstall January 2012
    14358460ForecourtLiveShell Black Cat (554)Closed for refit - reinstall 16th December 2011
    15366278ForecourtN/AShell Roydsbeck (381)Closed for refit - reinstall November 2011
    16353371ForecourtN/AShell Chase (508)Closed for refit - reinstall 16th November 2011
    17997ForecourtLiveClydeportPermanent closure
    18644122ForecourtLiveShell Sketty (2055)Closed for refit - reinstall 16th December 2011
    19302502ForecourtLiveShell Walworth South (048)Permanent closure
    20625435ForecourtLiveShell Gypsy Hill (346)Closed for refit, reinstall February 2012
    21347878ForecourtN/AShell Chandlers Ford (431)Closed for refit - reinstall January 2012
    22302635ForecourtLiveShell Teddington (052)Refit, reopening date unknown
    23302254ForecourtN/AShell Hospital Bridge (353)Closed for refit - reinstall December 2011

    FCT For Removal




    Result spreadsheet with 44 Rows

    Excel 2010
    CDEF
    2Venue CodeVenue TypeStatusREMOVAL REASON
    9648001ForecourtLiveSite burnt down, awaiting rebuild
    32661285ForecourtLiveSite burnt down, awaiting rebuild
    55661288ForecourtLiveSite burnt down, awaiting rebuild
    94661160ForecourtLiveSite burnt down, awaiting rebuild
    111347853ForecourtLiveClosed for refit - reinstall November 2011
    145308301ForecourtLiveClosed for refit - issue with new shop format, unknown reopening
    162302379ForecourtLiveRefit, reopening date unknown
    173661295ForecourtLiveSite burnt down, awaiting rebuild
    179349021ForecourtLiveClosed for refit - reinstall December 2011
    195398097ForecourtLiveClosed for refit - reinstall December 2011
    206661159ForecourtLiveSite burnt down, awaiting rebuild
    236644137ForecourtLiveSite burnt down, awaiting rebuild
    239644129ForecourtLiveSite burnt down, awaiting rebuild
    291308245ForecourtN/AClosed for refit - reinstall December 2011
    321661161ForecourtLiveSite burnt down, awaiting rebuild
    388661152ForecourtLiveSite burnt down, awaiting rebuild
    389661153ForecourtLiveSite burnt down, awaiting rebuild
    391661207ForecourtLiveSite burnt down, awaiting rebuild
    487380685ForecourtN/APermanent closure
    501661154ForecourtLiveSite burnt down, awaiting rebuild
    594661287ForecourtLiveSite burnt down, awaiting rebuild
    657661245ForecourtLiveSite burnt down, awaiting rebuild
    7046302ForecourtLiveRemoved, site closed
    748358212ForecourtLiveClosed for refit - reinstall January 2012
    792661206ForecourtLiveSite burnt down, awaiting rebuild
    808358460ForecourtLiveClosed for refit - reinstall 16th December 2011
    820366278ForecourtN/AClosed for refit - reinstall November 2011
    1080353371ForecourtN/AClosed for refit - reinstall 16th November 2011
    1094997ForecourtLivePermanent closure
    1105661294ForecourtLiveSite burnt down, awaiting rebuild
    1131661155ForecourtLiveSite burnt down, awaiting rebuild
    1254661286ForecourtLiveSite burnt down, awaiting rebuild
    1294644122ForecourtLiveClosed for refit - reinstall 16th December 2011
    1306302502ForecourtLivePermanent closure
    1309625435ForecourtLiveClosed for refit, reinstall February 2012
    1337661158ForecourtLiveSite burnt down, awaiting rebuild
    136712926ForecourtLiveRefit until 21st December
    1430347878ForecourtN/AClosed for refit - reinstall January 2012
    1485661289ForecourtLiveSite burnt down, awaiting rebuild
    1572661284ForecourtLiveSite burnt down, awaiting rebuild
    1579302635ForecourtLiveRefit, reopening date unknown
    1590302254ForecourtN/AClosed for refit - reinstall December 2011
    1607661291ForecourtLiveSite burnt down, awaiting rebuild
    1700661290ForecourtLiveSite burnt down, awaiting rebuild

    FCT3




    Any Ideas?
    Last edited by purceld2; Nov 29th, 2011 at 05:56 AM.

  2. #2
    Board Regular Easy-XL Support's Avatar
    Join Date
    Nov 2009
    Location
    Ottawa, Canada
    Posts
    140
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Unexpected results form Merge Function

    I'm working on this via email and will update this thread once we figure out what's going on.

  3. #3
    Board Regular Easy-XL Support's Avatar
    Join Date
    Nov 2009
    Location
    Ottawa, Canada
    Posts
    140
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Unexpected results form Merge Function

    The problem is that the column names needed to be in row 1 instead of row 2.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •