36374_en-US

liliconcom

What is the best way to assess if a column has an entry or not

Hi. I have the code below where I go through all columns on my table and add them to a list. It works fine. However, I just realized now that there is no point adding columns on my list that do not even include an entry (or is empty). Now I want to update my code below to include an "if" statement perhaps that if a column does not contain any data or entry, then I'll simply ignore it. What's the best way or method to implement this? Thanks.

 

 

// Populate X Group list
Insert Into( xGroupList, "Site" );
For( j = i, j <= N Cols( Data Table( a ) ), j++,
 Insert Into( xGroupList, Column( Data Table( a ), j ) << Get Name )
);

 

Re: What is the best way to assess if a column has an entry or not

Thanks! It worked.

Re: What is the best way to assess if a column has an entry or not

If(col number(:age),==0, ...... );

 

this works for both numeric and character columns