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 500002 Chennai null null3 null Raghu null
id location emp name nullcol2 chennai null emp name is null ,salary is null3 null Raghu loaction is null,salary is null
Any help is appreciated.