locked
Combine two .csv across a single variable RRS feed

  • Question

  • Hello! I'm super new to PowerShell, and I need some guidance.

    I'm trying take two .csv files and combine them across a single variable.

    csv1

    name,start,end
    Ashleigh,1/5/2019,4/5/2019
    Hunter,5/8/2018,8/8/2018
    Steve,6/25/2019,9/25/2019
    Jason,11/9/2015,2/9/2016
    Heather,3/22/2018,6/22/2018
    Sarah,7/16/2019,10/16/2019
    Jane,1/1/2017,4/1/2017

    csv2

    name,rehire,bonus
    Ashleigh,5/8/2019,500.00
    Hunter,8/25/2019,250.00
    Steve,10/22/2019,100.00
    Heather,7/13/2019,600.00
    Sarah,10/5/2019,50.00

    Desired output

    name,start,end,rehire,bonus
    Ashleigh,1/5/2019,4/5/2019,5/8/2019,500.00
    Hunter,5/8/2018,8/8/2018,8/25/2019,250.00
    Steve,6/25/2019,9/25/2019,10/22/2019,100.00
    Jason,11/9/2015,2/9/2016,,
    Heather,3/22/2018,6/22/2018,7/13/2019,600.00
    Sarah,7/16/2019,10/16/2019,10/5/2019,50.00
    Jane,1/1/2017,4/1/2017,,


    Any help on how to go about this would be incredibly useful.


    Wednesday, December 11, 2019 8:24 PM

All replies