About skriticos2

skriticos2 · ‎07-15-2020

Something like this would also work. Create a new column for each value in an mvfield, then use a transpose afterward. Is that possible? (I mean something like a foreach statement - not if/case - I have up to 70 values) header values (mv) ------------------- a a1 a2 a3 b b1 b2 c c1 c2 c3 c4 header values (mv) r1 r2 r3 r4 -------------------------------------------------- a a1 a2 a3 a1 a2 a3 b b1 b2 b1 b2 c c1 c2 c3 c4 c1 c2 c3 c4

skriticos2 · ‎07-15-2020

To illustrate from another perspective, I have a table where one column contains the field name and another the values (all properly sorted). Now I want to create a transposed table where each of the values goes into a separate row for the header that it belongs to. Tricky part is, that the number of values is variable. I think I have a dimension too much here for a simple mvexpand. A sideways mvexpand would help. So, I'm a bit stuck. header, values (mv field) a = { a1, a2, a3 } b = { b1, b2 } c = { c1, c2, c3, c4 } target table (each value in separate row/field) a b c ------------------- a1 b1 c1 a2 b2 c2 a3 c3 c4

skriticos2 · ‎07-15-2020

Thanks, but I've been there (actually that is a previous transformation to this). Having the data in multi value fields does not help me so far, as I want to expand them to a number of new columns (based on the number of values in the multi value field). And each row has a different number of values between 10 and 70. Something like an mvexpand command, but sideways would help me (creating new fields for each value), but I'm not aware of how to achieve that.

skriticos2 · ‎07-15-2020

Hi, I'm a bit stuck with a data transformation. I got it to a point where all the columns and values are in the right order, but the rows are offset for each column. I need to find a way to move the all the values in subsequent columns up to the top so they align. See below example of before/after data alignment I want to realize. Thanks for ideas! f1 f2 f3 f4 ---------------------------- foo bar baz x y a b 1 2 3 4 f1 f2 f3 f4 ---------------------------- foo x a 1 bar y b 2 baz 3 4

Posts	4
Solutions	0
Karma Given	0
Karma Received	0
Member Since	‎07-15-2020

Online Status	Offline
Date Last Visited	‎07-20-2020 04:28 AM

Move values in columns to top independently?

Re: Move values in columns to top independently?

Re: Move values in columns to top independently?

Re: Move values in columns to top independently?

Move values in columns to top independently?