Skip to main content
  • EN

Hi. I"ve a XLSX files. The XLSX files contain 2 sheets. Each sheets have common field (sample_ID). The first sheet is a description of the sampler, like the report name. In the second sheet it's the result of station. For each station it'S have many result ( 1 to M relation). I want to update a field in the second sheets with the value of the first sheet. But i have a error message (check the Capture files). Thank for help :)

Hi @hugues​,

In the Parameters for the output feature type, please set Use Attribute Names as Column Positions to 'No'. This is currently set to Yes, leading the writer to expect the attributes to have allowable Excel column names (ie. F, AA, BD, etc.). Changing to No will cause to writer to use the first row values as the column names.

Reply


Community Stats

30,123
Posts
114,333
Replies
37,751
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.