TotalConnect Function (Exclude Rows)

marcel_98

Hello everyone,

1. How to exclude rows by using conditions while doing mapping TotalConnect?

For example: Rows will be excluded when SiteName contains 'Facebook'

2. By using TotalConnect Function or Calculated Measurement, how to change Measurement value to 0 ?

Alex_Deliysky

Hi @marcel_98,

1. You have two ways to exclude rows from being uploaded. This is called a Data Load Rule.
- The first option is using the available feature for data load rules:
https://support.datorama.com/en/support/solutions/articles/4000085204-data-load-rules
- The second is by, what we call, a Manual Data Load Rule. This is a formula in the Day dimension of the Data Stream, which says for example:
if(csv['SiteName'] contains 'Facebook'){null;]
else{csv['date'];}
If the Day dimension is null, the whole row would not be ingested.

2. In order to just change the measurement value to 0, you need a similar syntax:
if(csv['SiteName'] contains 'Facebook'){0;]
else{csv['measurement'];}

Let me know if you need anything else

marcel_98

Thanks a ton of help ! You just save my time sir @Alex_Deliysky .

I think thats all. Again, i would like to say thankyou