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.
Does anyone have any idea how to resolve this?