Reply
Frequent Visitor
Posts: 7
Registered: ‎07-17-2018
Accepted Solution

Data from SQL database appears in preview but doesn't load - How to debug?

I'm experiencing a strange issue. I'm loading a table from a SQL database. I'm able to locate the data in the preview however it doesn't load to the actual dataset. See example below - product id 10051. I haven't applied any steps, it's just the source. Any ideas of how to debug this issue?

 

data-preview.PNGno-data-loaded.PNG

 

 


Accepted Solutions
Frequent Visitor
Posts: 7
Registered: ‎07-17-2018

Re: Data from SQL database appears in preview but doesn't load - How to debug?

The problem is solved. There was an issue with the sql statement used to access the tables in the database.

View solution in original post


All Replies
Community Support Team
Posts: 2,769
Registered: ‎02-06-2018

Re: Data from SQL database appears in preview but doesn't load - How to debug?

Hi nilst,

 

Have you clicked button "OK"?

捕获.PNG 

 

Regards,

Jimmy Tao

Frequent Visitor
Posts: 7
Registered: ‎07-17-2018

Re: Data from SQL database appears in preview but doesn't load - How to debug?

The problem is solved. There was an issue with the sql statement used to access the tables in the database.