Visitors table query results showing 0

Forum|Forum|2 years ago
January 5, 2024
1 reply
976 views

Hi everyone ,

I have loaded the data using Data loading activity and used Update activity to insert records in to visitor table. It shows 3 records inserted with email , firstname & url.

However when I use a query activity and choose Visitors schema in both filtering & target dimension, I see records in preview tab but when I run the query it shows 0 results.

Please suggest.

Thank you in advance.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Best answer by rvnth

when I updated the query from equal to To contains it started showing results. I am not sure if this is a bug

Marcel_Szimonisz

Community Advisor

Hello @rvnth,

you need to also specify query filtering conditions, when I tend to query all records I use 1=1 condition.

Can you send some screenshots of your settings?

Marcel

R

rvnthAuthor

Level 5

Hi @marcel_szimonisz ,

we have already added a filter with the location equal to the file name , in preview tab the data is populating but not in the final results when I run the query it shows 0 records.

Filtering condition:

3 records in preview with the above condition

0 results when i run the query

Thank you in advance

R

rvnthAuthorAccepted solution

Level 5

when I updated the query from equal to To contains it started showing results. I am not sure if this is a bug

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded