Forum Discussion
retrieve column name if empty
Hi there, I have some difficulties to combine text columns name with the result I want. If someone could help me to point me to the right direction please 🙂 So I have this table : Col1 C...
pls see the attachment below
what's the expected output based on the sample data you provided?
Could you pls update?
based on the example, I need to check a specific empty column name ( Col1, Col2,Col3) not all of the empty column.
Thanks alot
sry, still not understand your request. could you pls update the table below?
Col1 Col2 Col3 Col4 Wanted
A B Col3, Col4 B Col1, Col3, Col4 A C Col2, Col4 A Col2, Col3, Col4 B D Col1, Col3 Col1 Col2 Col3 Col4 Wanted
A B Col3 B Col1, Col3 A C Col2 A Col2, Col3 B D Col1, Col3 pls see the attachment below