How-to videos · 36 sec
Where did the two chairs go?
Ignore the update date in an inventory CSV and find the stock change that matters.
Read the transcript
Where did two chairs go? These inventory exports have six differences. Four of them are dates. Choose the two inventory files. Open Comparison options, then find CSV and TSV options. In Ignore columns, type Last Updated, exactly like the header. Run the comparison again. Two findings remain. The ergonomic chair dropped from eighteen units to sixteen. A new task lamp arrived with twenty-two units.