do you want the line to be removed from your data entirely (i.e. during load in the script)?
Or just from showing in table chart object? If latter, which object type do you use, which dimensions and expressions?
I understood that the fields reside in different tables, how are these fields linked to each other?