ACS Data Users Group

 View Only

  • 1.  Error in new Table Shells file (2015 1-year)

    Posted 09-08-2016 08:15 AM

    Anyone using the table shells file for ETL should be aware that the "UniqueID" column contains incorrect data for any table having 10 or more lines. It's easily fixed with an Excel formula like CONCATENATE(A5,TEXT(B5,"000")).



  • 2.  RE: Error in new Table Shells file (2015 1-year)

    Posted 09-08-2016 08:21 AM
    Thanks! good catch! I was just noticing the UniqueIDs being the same for so many - this explains it.


  • 3.  RE: Error in new Table Shells file (2015 1-year)

    Posted 09-09-2016 07:02 AM
    This error has been resolved. Thanks!