Solved: For input string: "1 ano" - Qlik Community

Anonymous · ‎2019-02-06

Hello, i have a large document in tfileinputExcel that pass trough an tMap

in metadata all the fields are String with only two exceptions(prices)

This is my metadata, and when i run my job i got this stupid issue "For input string"

The Field "1 ano" is inside [Garantia_Balcao]

You can check this out in my xls file above

Anyone can help me in this issue?

Anonymous · ‎2019-02-07

What you could try is this. I am not promising it will solve your problem, but I think there is a good chance it will.

1) Create a job which has a different flow for each each Excel sheet. So if you have 10 sheets, create 10 flows (Subjobs). One for each sheet. When you set up the Excel input file for each sheet, limit it to the sheet you want and specify only the schema for that sheet.

2) Create a parent job which will use the tFileList to pull the files in one at a time and iterate through the job I have described above. So essentially you have a tFileList---->tRunJob (calling the child job described above).

First test this with 1 flow in the child job. So something like this....

tFileInputExcel (only sheet1) -----> tLogRow

Then if that works, add the following....

tFileInputExcel (Sheet 1)----->tLogRow

|

| (OnSubJobOk)

|

tFileInputExcel (Sheet 2) -----> tLogRow

Then add a third sheet and fourth, etc.

Please be aware that any changes to the file that is supplied to you will create issues for your job. So it might be a good idea to try and negotiate a slightly better format from your supplier of files.

View solution in original post

Anonymous · ‎2019-02-06

Is the data returned properly or is it blank? Do you get any other messages other than that one?

Anonymous · ‎2019-02-06

Yes the data return properly,
I only got this "For input string" in other fields too in others Sheets

Anonymous · ‎2019-02-06

Hi,

I believe the metadata in the schema defined and your actual file are not matching.

There are some previous posts in our Talend community on the same issue. Could you please refer them too?

https://community.talend.com/t5/Design-and-Development/resolved-error-talend-For-input-string/td-p/1...

https://community.talend.com/t5/Design-and-Development/Error-on-run-shows-For-input-string-quot-599-...

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Anonymous · ‎2019-02-06

Hi,
I Already read all of these topics, but this is an alternative solution.
For one, or two fields this methods works properly
I got like 863 lines of this error "For input string" in differente Inputs of Excel.

" I believe the metadata in the schema defined and your actual file are not matching."
How my actual file have different schema ? could u please explain better?
I am using the Schema, and loading the same XLS.

Kinds Regards

Anonymous · ‎2019-02-06

Hi,

Could you please take a good record and bad record (which is giving this error) and compare them with text tool like notepad++ instead of Excel? Excel will auto format lot of details and may not be giving right results. Most probably you will find that the schema will have error where "1 ano" is going to Double datatype Street_price column (or even worse Gross price).

It might be for only certain records where the schema mismatch is happening.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Anonymous · ‎2019-02-06

Hello,

You mean to compare fields? Copy and Paste in Notepad ++ (or some text editor) two columns, one which error appears and another that works properly?

Please be more specified what u want me to do, with examples will be better to understand.

Regards,

Anonymous · ‎2019-02-06

Hi,

I was trying to say to open the input data file with textpad or notepad++ instead of excel. You do not have to use the entire data set and you can use a sample of 10 records for verification.

There could be layout changes in the data file. If you can share the current data file (after removing any sensitive information) and your job, I can also look the flow from my end.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Anonymous · ‎2019-02-06

Hi,

I did not understand how to open the input data in Notepad.

I Uploaded a sample of the Content in XLS for u and a Sample Job, in this job "1 ano" doesnt appear the error of For input string, but appears in other field

For input string: "UPC"

Also an image of my current job

You can check that the content of error changed, but still the same issue.

If u cant solve the problem, i will upload my full job and sheet.

Regards

dataforum.zip

akumar2301 · ‎2019-02-06

for UPC , it is not able to parse 1st record which is header.Please add header as 1 in tfileinputexcel.

I guess '1 ano issue' is resolved as it is parsed well in your sample job.

Also You can select die on error in tfileinputexcel to see where parsing fails actually.

For input string: "1 ano"

v7.x