Separate rows for multiple values

[Tom Tomasovic]

This is probably more relevant to eaXL than Word, but I think the functionality works the same.

When a single value can be attributed to multiple values, the Excel extract creates a single row for the element and a multi-valued column for the attributes.

It would be good/better if there was a row for each attribute or, perhaps, a row for each combination of element and attribute. Excel allows for this in the form of “nested cells (which seem to be used by eaXL)

E.g. instead of

[table]
[tr]
[td]Value 1[/td]
[td]Value a,Value b,Value c[/td]
[/tr]
[/table]

you had
[table]
[tr]
[td]Value 1[/td]
[td]Value a[/td]
[/tr]
[tr]
[td]Value 1[/td]
[td]Value b[/td]
[/tr]
[tr]
[td]Value 1[/td]
[td]Value c[/td]
[/tr]
[/table]

or
[table]
[tr]
[td]Value 1[/td]
[td]Value a[/td]
[/tr]
[tr]
[td][/td]
[td]Value b[/td]
[/tr]
[tr]
[td][/td]
[td]Value c[/td]
[/tr]
[/table]

Where the last table either has separate rows with blank values for “Value 1” in the second and third rows or, perhaps better, the cells for “Value 1” merged.

I hope this makes sense!

Thanks!

Tom

[David Berke]

Hi Tom,

Sorry, I am not replying with a response to your thread. I face the same issue and therefore am wondering if you ever found a solution to this issue?

Thanks,
David.

[Tom Tomasovic]

Hi David,

The best I could come up with would be to start the extract from the most granular level and work back to the higher levels. I.e., if you have an element which has several related values associated with it, start from the related values, extract them and then relate them to the parent element.

Hope this helps!

Tom

[Author]

Posts