Incomplete data extraction using Exoinsight tool in Alteryx

[ashwini09]

Hi everyone, 

 I am using exoinsight tool in Alteryx to extract data from database. The workflow is using a batch macro and the exoinsight tool is inside the batch macro. The query that is being passed to the exoinsight tool needs to be applied for 80 countries, and these 80 countries are provided as input to the batch macro in the workflow.

The workflow is running fine, except the output is not getting extracted for all countries, even the data is available in the database. In every test run, data for the few countries which are not fixed in number and name, are not getting populated.

If in a test run, country A, B, C, D, E are not having data, it might be the case that in the 2nd test run, country A,D,E,X would not be having data and country B, C would be having correct data.

So, does anyone have faced this or is having any solution for this issue?

[mathieuf]

Hi @ashwini09, can you please use the english forum for english question.

It will be easier to get answer and for people to find this topic.

Thanks.