Shift Column Down RRS feed

  • Question

  • Hello. I have an assignment I *have* to solve using SSIS. I have to clean my data, which is stored in an Excel file. I have the following problem:

    My first column is shifted up from the rest, which gives this result:

    value | *null*

    value | value

    value | value

    *null* | value

    where there should only be aligned values.

    I was wondering if someone could help me find the right transformation to fix these data. I think the solution is to shift that column down, but I don't know how to do it. Any advice is welcome! Thanks a lot!

    Saturday, April 20, 2013 9:57 PM


  • Use a script component with a variable.

    Within the script add new column with current value of the variable and then copy column 1 into variable.

    Variable will store value from the previous row.

    • Edited by Piotr Palka Sunday, April 21, 2013 1:30 AM
    • Marked as answer by Eileen Zhao Friday, April 26, 2013 2:32 AM
    Sunday, April 21, 2013 1:29 AM