I have 4 sets of data (machine names from different products) the machine names should exist in all 4 data sets. I am trying to output the data into 4 columns and if a machine name is missing from 1 data set a blank line is left so all results are aligned and easy to spot anything missing. Can someone please help?
just got home and completed your 4 steps, you are right that does give me what’s missing from each original array. But for my clean up task I need to know which arrays they exist in so I can delete those objects before I can deploy the machines again…hope that makes sense
Thanks Rob, that looks good but only issue is I’m dealing with 5000+ machines so the output is messy. still keen to get in a CSV format, like the below