Visitors table query results showing 0

[rvnth]

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.

[Marcel_Szimonisz]

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

[rvnth]

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

[rvnth · Accepted solution]

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]

Hello @rvnth,

it should find exact match, can you list what are the values? 

Marcel

[rvnth]

@Marcel_Szimonisz  I am using the location of the file name as value which will be like d://adobe campaign//file_name