Solved: [resolved] How to extract specific cell from multi... - Qlik Community

Anonymous · ‎2014-10-08

Hye,
I need to extract specific cell from multiple excel in a folder.
But, I have a problem which is the output is repeated.
How to solve the problem? Here, i attached the screenshot what im used to show the output.

Anonymous · ‎2014-10-09

At first you do not reset the sequence, means every file the sequence value will grow.
Next you write the context variables once but never again, because of that you will always get the same value.
To get an idea what I mean I suggest you set null the values before you set the values, you will see you get mostly null values instead of always the same value.
I would use a tJavaFlex instead of tJavaRow and reset the sequence in the begin part or use simply the file name as name for the sequence.

View solution in original post

Anonymous · ‎2014-10-08

The resolution of your screenshot is to low to spot anything on it.
What do you mean with "The output is repeated". The tFileInputExcel component is fairly simple and start reading from the start row until the last row and starts with the start column until the last schema column is reached.
To get one value you have to specify one schema column and setup the start and end row according to your needed position.
If you find that a bit cumbersome (me too) you could try the alternative Excel component tFileExcelReferencedCellInput. This component can read a particular cell addressed by row/col or the Excel address expression "D1" on a specific sheet.

Anonymous · ‎2014-10-08

The output is repeated means I have input from multiple excel in a folder, when run the job execution the output read from the first excel only... so, all the output are same..

Anonymous · ‎2014-10-08

Hi,
Can you show the settings for your excel component?
vaibhav

Anonymous · ‎2014-10-08

Hi, here attached the setting tfileinputexcel..TQ

Anonymous · ‎2014-10-08

hi,
sorry but we still not seeing your screenshoot clear enought.
regards

Anonymous · ‎2014-10-08

sorii..here, there is new attachment for your reference....

Anonymous · ‎2014-10-08

Hi,
Suppose you want to read cell on 5th row and 3rd column then you can set following properties in your tFileInputExcel component
- Set header - 4
- Start column position - 3
- End column position - 3
- Set Limit to - 5
Try above... while doing so you will get an idea.
Thanks
Vaibhav

Anonymous · ‎2014-10-08

The reason for getting always the same values must be in the tJavaRow. You design to iterate through the files with tFileList and read every file with tFileInputExcel is fine and should work.
For us between the reading from the excel file and the log output there are a lot of not visible steps and I am sure you will find here the problem. If you need held, please tell us what you do in the tJavaRow and the tFixedFlowInput.

Anonymous · ‎2014-10-08

Hi, jlolling...
Here, there is new attachment for reference.. Example, I want to get source from B4, B5 and J1..TQ...

[resolved] How to extract specific cell from multiple excel in a folder

Talend Data Integration

v5.x