Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2018-06-14 04:53 PM

Error: For input string: "Realizado"

I can't insert data from Excel to Db table.

I have a column in the excel called Previsto/Realizado and on my DB as well, both string.

On both metadata, the column is a String, so it should be working but it's not.

 Log error:

 

Starting job jb_ocorrencias at 16:37 14/06/2018.

[statistics] connecting to socket on port 3675
[statistics] connected
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"
For input string: "Previsto"
For input string: "Realizado"

[statistics] disconnected
Job jb_ocorrencias ended at 16:38 14/06/2018. [exit code=0]

 

Labels (2)
Labels
151 Views
0 Likes
1 Reply
Jesperrekuh
Specialist
Specialist
‎2018-06-14 05:18 PM

By looking at your XLSX ... thats planning for failure (from an ETL perspective). VLOOKUPs

In Talend tFileInputExcel, read sheet : Exces.*  and dump to log:



To see the whole post, download it here
OriginalPost.pdf
151 Views
0 Likes