Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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    Col2  Col3  Col4        Wanted

AB  Col3, Col4
 B  Col1, Col3, Col4
A C Col2, Col4
A   Col2, Col3, Col4
 B DCol1, Col3

 

Need Help

9 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi ryan_mayu,

    Thanks for this exemple, it help me a lot, i have a last need, i need to get a specific empty column name not all of them, what is the fonction to add for that please ?

    Regards,

    ZeNab

    • ryan_mayu's avatar
      ryan_mayu
      Super User
      3 years ago

      what's the expected output based on the sample data you provided?

      Could you pls update?

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        based on the example, I need to check a specific empty column name ( Col1, Col2,Col3) not all of the empty column.

        Thanks alot

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi ryan_mayu,

    Thanks for this exemple, it help me a lot, i have a last need, i need to get a specific empty column name ( Col1, Col2) not all of them, what is the fonction to add for that please ?

    Regards,

    ZeNab