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.
Solucionado! Ir para Solução.
@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.
@Qiu Thanx for the quick response. It worked Fine
@DataPirate26
Glad to know it helps.
@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.
@DataPirate26
For this situation, I usually use the Dynamic Rename to bring the Column Name back.
@Qiu Awesome. Thanx for the help and this is a great way to solve this kind of Small issues
@DataPirate26
Glad to help.