What is the best way to assess if a column has an entry or not
Feb 24, 2017 4:29 PM(4817 views)
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 )