November 22, 2015 at 8:59 am
I'm looking for some specific documentation from Microsoft that will ease my troubled mind. I have to be able to ensure, with 100% reliability, that the spreadsheet I'm bringing in will not change at all during the import to a Raw table.
The data comes from a public entity and is basically a report. First 4 rows are garbage, no problem, I can kill those. The next row hows columns 1 through 9. The problem is that Colume 3 and 4 are on top of each other. Column 3 is a unique identifier for that group of data, and column 4, which is the very next row, is the date (also very important).
There is usually a blank space between the various groups of data, so I can handle that as well; however, if the data is shifted in anyway, it's corrupted and I lose the relationships I need.
Names State Id/Date Gender
Sylvester Tx 2 M
Tweety Tx 5/21/1969 ?
Daffy Tx M
Speedy Tx M
Donald CA 3 M
Daisy CA 4/15/2015 F
Rosy CA F
ETC., ETC.
If this doesn't make sense, I'll do some more 'splanin... I'm researching a script task to open the spreadsheet, and move the ID and Dates to their own columns and copy them for every element in that row., but If I have assurances that the file won' change on the way in, I can do it in the Raw table.
Thanks in advance.
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply