Skip to main content
Solved

Fanning out different attribute schemas to different Excel tabs

  • December 19, 2024
  • 1 reply
  • 33 views

p_c_20
Contributor
Forum|alt.badge.img+8

Am creating three sets of numbers from one source file. Each set has a different attribute structure. 

I want to fan these out into separate tabs of an Excel spreadsheet, using a created attribute that is common to the three streams, but has a different value for each. 

Have tried every permutation of setting I can think of in the Writer/dynamic schema defn, and cannot get it to respect the three different attribute schemas. 

Feels like this should be easy, but…..🤔

Best answer by jdh

p_c_20 wrote:

Am creating three sets of numbers from one source file. Each set has a different attribute structure. 

I want to fan these out into separate tabs of an Excel spreadsheet, using a created attribute that is common to the three streams, but has a different value for each. 

Have tried every permutation of setting I can think of in the Writer/dynamic schema defn, and cannot get it to respect the three different attribute schemas. 

Feels like this should be easy, but…..🤔

If each tab has a different schema, then you need to either send a schema feature in advance of the data features, or have the schema attached to each data feature.

The SchemaScanner is the easiest way to accomplish this.

 

View original
Did this help you find an answer to your question?

1 reply

jdh
Contributor
Forum|alt.badge.img+28
  • Contributor
  • Best Answer
  • December 19, 2024
p_c_20 wrote:

Am creating three sets of numbers from one source file. Each set has a different attribute structure. 

I want to fan these out into separate tabs of an Excel spreadsheet, using a created attribute that is common to the three streams, but has a different value for each. 

Have tried every permutation of setting I can think of in the Writer/dynamic schema defn, and cannot get it to respect the three different attribute schemas. 

Feels like this should be easy, but…..🤔

If each tab has a different schema, then you need to either send a schema feature in advance of the data features, or have the schema attached to each data feature.

The SchemaScanner is the easiest way to accomplish this.

 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings