locked
Import 2 CSVs, Find matching Rows and Calculate difference between cells of those Rows RRS feed

  • Question

  • Hi Guys,

    Ive got myself in a complete mess with this one, having tried several different methods, and spent hours failing! So its time to seek advise from the experts and start fresh (again). I'm hoping I have just overlooked something simple or not found similar forum answers, however, The synopsis:

    I currently generate a csv each week that displays 4 columns (Date, Dir Name, Dir Path, Dir Size). The data is a report of Folder sizes from a given source.

    I would now like to:

    - calculate the % difference between Dir sizes of any matching rows from the latest csv; compared to the previous weeks csv.

    - export the Dir Name, Dir Path and newly calculated %diff, to another csv.

    - If there isn't a match in the new file, then append something saying 'Old Dir no longer exists'

    - If there isn't a match in the old file, then append something saying  'Newly created Dir'

    Hope someone can help.

    thanks

    Tuesday, February 26, 2019 1:16 PM

All replies