You are not logged in.

Unanswered posts



Important! This site has been replaced. All content here is read-only. Please visit our brand-new community at https://community.talend.com/. We look forward to hearing from you there!



#1 2016-09-21 19:28:06

JSeverino
Member
31 posts

JSeverino said:

[resolved] tFileExcelSheetInput same data in different columns

Hello community!
I'm quite new using Talend, and for solving an Excel reading problem I'm using tFileExcelSheetInput component (works very good!), but I can't make it work with a file like the image attached.
The data is separated in several and dynamic columns, each column have a number as column name (you can see the config of the component and the error message on the attached image)...
Is there any way to read this kind of format/schema?
mini_blob_20160921-1128.pngmini_blob_20160921-1129.png
mini_blob_20160921-1130.png

Last edited by JSeverino (2016-09-21 19:30:31)

Offline

#2 2016-09-22 04:18:18

xdshi
Talend Team


xdshi said:

Re: [resolved] tFileExcelSheetInput same data in different columns

Hi,
tFileExcelSheetInput is a custom component written by talend community user and shared on talend exchange portal.
Feel free to contact the author jlolling directly.
Best regards
Sabrina


What we can do is to make sure that Talend will be your best choice!

Offline

#3 2016-09-22 13:46:24

JSeverino
Member
31 posts

JSeverino said:

Re: [resolved] tFileExcelSheetInput same data in different columns

Thank you Xiado Shi, I already did that! wink
I'll share the answer here.

Offline

#4 2016-09-22 14:29:11

jlolling
Member
3186 posts

jlolling said:

Re: [resolved] tFileExcelSheetInput same data in different columns

I will take a look at it. Actually it should work.


Talend Certified working for cimt objects AG in Berlin

Offline

#5 2016-09-23 10:48:10

jlolling
Member
3186 posts

jlolling said:

Re: [resolved] tFileExcelSheetInput same data in different columns

Sorry for the late answer. NO it cannot work, because the regex expression must select exactly one distinct column and your expression points to multiple columns. There is no kind of iteration implemented. I will improve the error message because indeed this message is misleading in this case.

Last edited by jlolling (2016-09-23 10:49:26)


Talend Certified working for cimt objects AG in Berlin

Offline

#6 2016-09-23 13:05:55

JSeverino
Member
31 posts

JSeverino said:

Re: [resolved] tFileExcelSheetInput same data in different columns

Ok,
Thank you Jan. In your experience, what can I do for read this kind of Excel? 

Offline

#7 2016-09-23 13:21:51

jlolling
Member
3186 posts

jlolling said:

Re: [resolved] tFileExcelSheetInput same data in different columns

Are your columns always differently named (always different numbers) ?
If you want to read the column e.g 5 always for the same schema column, simply type 5 as column name (in this case you do not need regex).
If you want to read always the same excel column - regardless what number is set as header then address the column fix.
or you have to explain a bit more how your use case should work. 


Talend Certified working for cimt objects AG in Berlin

Offline

#8 2016-09-23 14:00:32

JSeverino
Member
31 posts

JSeverino said:

Re: [resolved] tFileExcelSheetInput same data in different columns

Ok,
Columns names are always numbers in sequence: 1, 2, 3..., n (dynamic)
Each column have 18 rows (excluding header).

I need to read for every column, every row. In order tu put the data in a database with this columns:

instrumentDate | instumentName | columnNumber | tickerName

Using the image from my first post, I should get something like this:

13-09-2016|US1234567890|1|Data 1
13-09-2016|US1234567890|1|Data 2
13-09-2016|US1234567890|1|Data 3
13-09-2016|US1234567890|1|Data 4
13-09-2016|US1234567890|1|Data 5
13-09-2016|US1234567890|1|Data 6
13-09-2016|US1234567890|1|Data 7
13-09-2016|US1234567890|1|Data 8
13-09-2016|US1234567890|1|Data 9
13-09-2016|US1234567890|1|Data 10
13-09-2016|US1234567890|1|Data 11
13-09-2016|US1234567890|1|Data 12
13-09-2016|US1234567890|1|Data 13
13-09-2016|US1234567890|1|Data 14
13-09-2016|US1234567890|1|Data 15
13-09-2016|US1234567890|1|Data 16
13-09-2016|US1234567890|1|Data 17
13-09-2016|US1234567890|1|Data 18
13-09-2016|US1234567890|2|Data 19
13-09-2016|US1234567890|2|Data 20
13-09-2016|US1234567890|2|Data 21
13-09-2016|US1234567890|2|Data 22
...

Offline

#9 2016-09-23 16:27:10

JSeverino
Member
31 posts

JSeverino said:

Re: [resolved] tFileExcelSheetInput same data in different columns

I make it work with a tLoop. Is not an elegant solution but it's work (I'll take a better look later).
Now I have to get A1 and B1 cells, and I do it in a different flow... But now I can't  "merge" this two flows (I try with unite and tmap)... what do I missing?
mini_blob_20160923-0827.png
mini_Captura.jpg.jpg
mini_blob_20160923-0830.png

Last edited by JSeverino (2016-09-23 16:30:30)

Offline

Board footer

Talend Contributor Agreement - Talend Website Privacy Policy