Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is there a way to exclude blanks or nulls after using an if then statement in Data Mapper?
Here's the tHMap - I'm using the if then statement for output field Type, but since there's more types, they're being written as blanks or nulls. How do I exclude values I don't want?
Here's the result of the test run. I don't want to write out the Type with blanks or nulls (highlighted fields on screenshot below). Is there a way to map an if then statement and then check if that same field has a value?
How would I remove null rows? The mapper is writing the output as an array for that one column.
How would I remove null rows? The mapper is writing the output as an array for that one column.