Is there a way to use global property to filter out empty rows? @met contains the property name of "XXX Metabolizer Status". Because the "XXX" part of the name could varies depending on the source file. I thought I would capture the name using global variable. In the end, I would like to filter out rows where "XXX Metabolizer Status" equal blank and keep only data records where "XXX Metabolizer Status" property is populated. Below are the codes.
FOR #i IN 1 .. NumProperties()
LOOP
If IthPropertyName(#i) RLIKE '[M][e][t][a][b][o][l][i][z][e][r]' THEN
@met := IthPropertyName(#i);
END IF;
END LOOP;
----- in the custom filter component, i have the following code. But, it did not work. data records where "XXX Metabolizer Status" is empty are still in the output. Is it because it has space in the property name? if that's the case, how can i fix that? will appreciate any help! Thank you!
@met ne " ";