Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Geeting list of null column values from table and adding to new column

Geeting list of null column values from table and adding to new column

New Contributor

Hi,

I have a use case where i need to capture the list of null value columns in to a separate column in destination table.

This is how my data loks.

id location emp name salary

1 Hyd Ram 50000
2 Chennai null null
3 null Raghu null

output expected

id location emp name nullcol
2 chennai null emp name is null ,salary is null
3 null Raghu loaction is null,salary is null

Any help is appreciated.