[resolved] Guess Schema in Input Component

Four Stars RSH
Four Stars

[resolved] Guess Schema in Input Component

Dear Team,
Scenario:
I have source query of Sql server which made up of 14 tables ( various left outer join + inner join). I need to select 25 columns from these 14 tables.
Fail in Execution:
I click on "GUESS SCHEMA" but it gives an error. Please refer screenshot
Those errors can be anything.
Requirement:
Its difficult to create schema for those 25 columns manually. Do we have any alternative idea so that Talend himself generate schema for written query ?
Please let me know incase we have any alternative to get schema automatically.
Thanks in advance.
One Star

Re: [resolved] Guess Schema in Input Component

Hi RSH,
Its difficult to create schema for those 25 columns manually. Do we have any alternative idea so that Talend himself generate schema for written query ?

I tried this, & successfully achieved it.
So, just a check: Did you put your entire query within "double quotes"? the way Talend expects it.
Hope this helps. Smiley Happy
Let me know if this doesn't.
MathurM
One Star

Re: [resolved] Guess Schema in Input Component

And also, one of the 25 tables should be selected in the 'Table Name' box. (But, I guess, you might be already doing that Smiley Tongue )

Calling Talend Open Studio Users

The first 100 community members completing the Open Studio survey win a $10 gift voucher.

Start the survey

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Why Companies Move to the Cloud: 7 Success Stories

Learn how and why companies are moving to the Cloud

Read Now