Forum Discussion

SABSLI's avatar
SABSLI
Copper Contributor
May 26, 2020

transform data (ssis)

Hello  I work on a client project which consists in monitoring the time allocations of the employees. a file is extracted from the platform which allows the entry of times but this file does not app...
Business Intelligence
Integration Services
bake13's avatar
bake13
Icon for Microsoft rankMicrosoft
May 27, 2020

Hi SABSLI --  What version of SQL Server are you using?  Also, I be misinterpreting your attached spreadsheet, but it appears to me that there is data for three individuals listed, not just two.

 

1.  Johnana Lama

2.  Rosalinda Riviere

3.  Patrick Lama

 

Or are you just wanting to ignore the data for the second person in the spreadsheet?

  • SABSLI's avatar
    SABSLI
    Copper Contributor
    May 28, 2020

    HI bake13 

    Thank you for your answer

    i am using sql server 2017 standard edition 

    effectively there is 3 persons on the file 

    i've added in this msg the result that i want obtain (tab= result)

    thanks

    best regards

    • bake13's avatar
      bake13
      Icon for Microsoft rankMicrosoft
      Jun 03, 2020

      Hi SABSLI --  Apologies for the delay.  I think this can be accomplished using either a derived column or conditional split or some combination of the two.  This might be a bit challenging given the structure of the source data.

       

      As soon as time permits, I will try to create an example package.

      • Simple_Balayeur's avatar
        Simple_Balayeur
        Brass Contributor
        Jun 05, 2020

        Hi and good day:)

         

        1)When I first read the original post: I saw some 'confusion' which you where helped for.

        2)When I read the last post about derived column it made sense

        3)Still there is a 2% chance of error.

        4)Maybe you should reformulate question with new data points (2)

         

        Have a great day

Resources