Discard Columns (Multiple) which has null values in the First Row dynamically

[DataPirate26]

Hi Everyone, 

I want to discard Multiple Columns which has null() values in the First Row at once. With the help of Dynamic Select I was unable to do so. Is there a way out to achieve this ?

[Pang_Hee_Choy · Accepted solution]

using dynamic rename to add name to the description. (view in metadata)

then use dynamic select to remove any columns that have description.

[flying008 · Accepted solution]

Hi, @DataPirate26 

FYI.