public async Task TestFilterRemainItemsForValue()
        {
            var data = GenerateData();
            var f    = new FilterRemainItemsForValue("FirstName", "1", FilterType.Contains);

            f.valuesRead = data;
            await f.Run();

            //remain 1 and 10
            f.valuesTransformed?.Length.ShouldBe(2);
        }
        public async Task Run()
        {
            IFilter filter;

            if (InvertCondition)
            {
                filter = new FilterRemoveItemsForValue(ColumnName, ValueSearch, FilterType);
            }
            else
            {
                filter = new FilterRemainItemsForValue(ColumnName, ValueSearch, FilterType);
            }
            filter.valuesRead = this.valuesRead;
            await filter.Run();

            valuesTransformed = filter.valuesTransformed;
        }