You can translate the question and the replies:

How to get data from different sources, without errors.

I have an selected view that uses like input an excel file, and I have another selected view that uses a CSV file like input. I want to have an union with those selected views, but if one file is missing I get an error. How can I avoid this error? I want this union, because the logic is that if the CSV file is not present we will use the EXCEL file.
user
02-06-2020 07:36:06 -0400

4 Answers

Hi, If I want to perform **Union** operation between Excel and CSV files by ignoring the missing files, I would enable the option **Ignore route errors** in the Delimited Datasource. By enabling this option, I was able to avoid the errors from CSV files and retrieve the results of union view successfully. Additionally, if there is a data level error like the CSV file that do not have the expected structure, then you could make use of the **Ignore matching errors**. If this is enabled, the Server will ignore the lines of this data file that do not have the expected structure. You can have a look at the [**Delimited File Sources**](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/creating_data_sources_and_base_views/delimited_file_sources/delimited_file_sources) for more information. Hope this helps!
Denodo Team
03-06-2020 09:11:39 -0400
Great. Thank you! And if I have a CSV and a JDBC connection and the JDBC connection fails or the Base View from the database fail, can I do something similar? I would like to have the CSV data if JDBC connection fails.
user
03-06-2020 09:24:29 -0400
Hello, any update? I would like to know if I have a CSV and a JDBC connection and the JDBC connection fails or the Base View from the database fail, can I do something similar? I would like to have the CSV data if JDBC connection fails. Thanks
user
09-06-2020 04:02:29 -0400
Hi, When I tried to create an Union operation between a CSV file and JDBC view, if there is any problem with the JDBC connection, I was able to retrieve partial results (from CSV) along with the error thrown from JDBC connection. Also, I believe that there is no option like **Ignore route error** in any datasource other than Delimited datasource for avoiding errors from a failed connection. Hope this helps!
Denodo Team
16-06-2020 02:32:27 -0400
You must sign in to add an answer. If you do not have an account, you can register here