I have 2 columns in dt_Combined DataTable and need to filter “sales” and “customer”. (dt_Combined DataTable doesn’t have any null or empty values in both columns.)
My conditions may be a bit tricky.
It is not always true that SalesID and CustomerID have values.
Sometimes, either SalesID is empty OR CustomerID is empty.
(Both may not be empty simultaneously.)
If SalesID is empty and CustomerID is “AAA Company”, I need to extract “sales” = all sales and “customer” = “AAA Company”.
If CustomerID is empty and SalesID is “123456”, I need to extract “sales” = “123456” and “customer” = all customer .
However now, if SalesID (or CustomerID) is empty, Filter DataTable returns zero outputs in dt_FilteredTemp. (Probably, Filter DataTable Activity literally searches for empty cell in “sales” column, whereas it is no-null column.) It was just same even if I used IF & ASSIGN Activities to fill asterisk in ID, whenever either of IDs is empty.
I am not trying to search for data with some keyword with wildcard e.g.) ‘Product*’.
SalesID is not provided always, only sometimes. But dt_Combined dataset is always “non-null”. If I try to leave SalesID empty, filtering function tries to search “empty” or null row from dt_Combined, whereas such rows do not exist. Oppositely, if trying to put asterisk in SalesID, filtering function tries to search “asterisk” in dt_Combined, whereas such rows do not exist. It could be because asterisk is considered “one string”.