How to remove columns with null value alone in pipeline?
Hi,
I have a scenario where I have few columns have null value few not. Objective is to not to bring in columns with null value for each records.
source:
| id | a | b | c | d | e |
|---|---|---|---|---|---|
| abc | null | 1 | 2 | null | null |
| def | 11 | null | 22 | 33 | null |
| ijk | 111 | 222 | null | 333 | 444 |
| lmo | null | null | null | null | 5555 |
Expected:
abc 1 2
samething with other records as well. Does anyone know any trick on this? Please let me know.
Regards,
Amar.
