I am trying to clean up some invoices and when imported to Alterytx they get kinda funky. I know I can user the cleaner tool to get rid of the Null values but than Im just left with a blank cell.
Invoice Date | 6/16/2020 | Null | Null | Null |
Customer ID: | Null | Null | Null | 123456 |
Order #: | Null | 567890 | Null | Null |
Item ID | Null | Null | Null | 12221 |
Item Serial # | Null | Null | 9876545678 | Null |
This is what I would it to look like. I want to be able to eliminate the empty cells and pull the other values in to the adjacent cell.
Invoice Date | 6/16/2020 |
Customer ID: | 123456 |
Order #: | 567890 |
Item ID | 12221 |
Item Serial # | 9876545678 |
Solved! Go to Solution.
@bpatel
Thanks that seems to be exactly what I need. One slight problem. On my workflow for some reason the null is greyed out so it doesn't seem to filter out he null rows like it does for your example here.
hi @Inactive User ,
In your filter try to use "isnull" that should help!