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
Join us to spark ideas for how to put the latest capabilities into action. Register 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
‎2016-01-07 02:05 AM

Dynamic InputFile schema and Dynamic Table creation

Hi All,
I am new to Talend and given challenge where one of our client will send Inputfile which is dynamic in structure (no of columns and Datatypes are dynamic). I have to get the file and create a table dynamically for the inputfile.
Is there anyway to create a Talend Job which takes source as dynamic file schema and creates target table dynamically?
A Swift responce will be very glad.
Please let me know if my requirement is not clear.
Thanks,
Archana Laddagiri
email:laddagiri.archana@gmail.com
Labels (2)
Labels
412 Views
0 Likes
7 Replies
Anonymous
Not applicable
‎2016-01-07 04:24 AM
Author

Hi,
Use below flow-
tfileInputDelimited- > tmap -> DB component (tOracleOutput in case DB is oracle).
In the schema of tfileInputDelimited define only one column and datatype as 'Dynamic'. Copy the same flow till DB component and select option 'Create tbale if doesnot exist' from the drop down 'Action on Table' in DB component.
412 Views
0 Likes
Anonymous
Not applicable
‎2016-01-07 06:22 AM
Author

Hi,
The given solution works with Talend Commercial/Enterprise edition,but we are working with TalendOpenStudio (TOS).
Is any component/workaround there in TOS?
Thanks,
Archana Laddagiri
412 Views
0 Likes
Anonymous
Not applicable
‎2016-01-07 11:20 PM
Author

Hi,
Talend provides community user with a free trial of Talend Data Integration Product.
You can download it freely from:https://info.talend.com/prodevaltedi.html?_ga=1.203997008.1751069238.1426242863
Best regards
Sabrina
412 Views
0 Likes
Anonymous
Not applicable
‎2016-01-11 12:11 AM
Author

Thanks Sabrina,
But in DB, I am able to see single column instead of 2 columns.
my file is
id,name
100,abc
101,xyz
102,zzz
my target in SQLservrDB should be 2 columns as id and name. but I got table with single column as
id;name
100;abc
101;xyz
102;zzz
here by Iam attaching the scrrenshots of my job
is there any properties had I overlooked?
Thanks,
Archana Laddagiri
412 Views
0 Likes
Anonymous
Not applicable
‎2016-01-11 08:58 AM
Author

Looks like your file field delimiter is set incorrectly.
412 Views
0 Likes
Anonymous
Not applicable
‎2016-01-11 02:41 PM
Author

Thanks janhess2,
I have corrected my file properties and it worked. ( in tfileinputdelimiter I have changed the fieldseperator from "," to ";")
BUT I am looking for any possibilities with Talend Open Studio version.
Please share your inputs.
Thanks,
Archana Laddagiri
412 Views
0 Likes
Anonymous
Not applicable
‎2016-01-12 10:35 PM
Author

Hi Archana Laddagiri,
With talend open studio, you have to define the schema structure (names, types, and number of columns) during design to load your input file.
Best regards
Sabrina
412 Views
0 Likes