Skip to main content
  • EN
Hello,

 

 

I would like to read excel files containing one sheet only. But columns headers may not be same apart from 2 columns Lat and Long. I am using VertexCreater to create point from Lat,long.

 

 

e.g. Excel1.xls contains A,B,C,Lat, Long

 

Excel2.xls contains C1,C2,C3,C4,Lat, Long,C5,C6

 

Excel3.xls contains Lat,Long,A1,B1,C1

 

 

How can I read excel file with dynamic scheam and retain all attributes for destination format.

 

 

Cheers.
Hi,

 

 

In my understanding, a writer with Dynamic Schema identifies a schema source by the feature type name. And, in the Excel format, worksheet names will be treated as feature type names. So I think the dynamic schema mechanism may be used if every worksheet name is unique. Otherwise, it may be hard.

 

 

Takashi

Reply


Community Stats

30,108
Posts
114,295
Replies
37,743
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.