Discard All columns when the 1st row is Blank or Null

Hi all,

I want to Discard all the columns in which the 1st row is null or blank. attached below is a sample. Can someone help me in this.

I only need the Columns: BBDO Inc. and BBDO Chicago. in the below sample. rest all needs to be discarded.

Note: There are 100 fields. So I have to do this dynamically. This is just one sample.

Discard Columns.yxmd

Dynamic Processing

Accepted answers

Qiu

@DataPirate26
I would use the sample tool to take the first row then use Transpose to rule out the Null value, which shall be filtered out.

For details refer below.

Discard Columns-r1.yxmd

Qiu

@DataPirate26
For this situation, I usually use the Dynamic Rename to bring the Column Name back.

Discard Columns-r2.yxmd

All comments

Qiu

@DataPirate26
I would use the sample tool to take the first row then use Transpose to rule out the Null value, which shall be filtered out.

For details refer below.

Discard Columns-r1.yxmd

DataPirate26

@Qiu Thanx for the quick response. It worked Fine

grazitti_sapna

@DataPirate26 , here is another way to do this:

Qiu

@DataPirate26
Glad to know it helps.

DataPirate26

@Qiu @grazitti_sapna Thanx for your quick response. I actually am facing one challenge in this. Basically few of the headers have characters Like "&" , "." in it which are also replaced by "_". when doing a Crosstab.

Example: "Patients & Purpose" "Agency.com" . The results are coming like Patients_Purpose and Agency_com. I can replace the "_" with a black space but that doesnt give me the original Headers. Can you help me out so that I can retain the original headers.

Qiu

@DataPirate26
For this situation, I usually use the Dynamic Rename to bring the Column Name back.

Discard Columns-r2.yxmd

DataPirate26

@Qiu Awesome. Thanx for the help and this is a great way to solve this kind of Small issues

Qiu

@DataPirate26
Glad to help.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703