vMix Forums
»
General
»
GT
»
Convert rows to columns not working?
Rank: Newbie
Groups: Registered
Joined: 11/21/2020(UTC) Posts: 4 Location: Guildford
|
I've been testing out the data sets feature, which is awesome, however in my particular case I'd rather have the data sets (normally rows) going across as columns. Just makes more sense for the people entering it. Everything works perfectly if I format it the way vMix prefers - with rows being a new data set, and columns being the headers. If I switch my spreadsheet around so that it's the other way (preferable visually) and then switch "convert rows to columns", the data does not load correctly. It's not the end of the world, but it just makes no sense. I would expect that it would just flip around and continue to work as normal, however it completely misinterprets the data. Attachments: - two CSVs of the same data, as far as I can tell. One using rows, other using columns
- Screenshots of the problem.
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 11/21/2020(UTC) Posts: 4 Location: Guildford
|
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 12/27/2012(UTC) Posts: 5,243 Location: Belgium Thanks: 294 times Was thanked: 960 time(s) in 794 post(s)
|
That's not how it's meant to interpret
always use a standard table : headers and data per row
if you convert rows to columns in vmix each row will be placed behind the previous and the headers will get a sequential number This was done to be able to place data from several rows in one title (columns specified by the sequential number) was useful for example for rankings display and such before selectrow shortcut availability
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 11/21/2020(UTC) Posts: 4 Location: Guildford
|
thank you for the reply. It seems counter-intuitive to me, but I can use a =transpose function to change the rows/columns around onto a different sheet, and do it that way. Thank you for the reply.
|
|
|
|
vMix Forums
»
General
»
GT
»
Convert rows to columns not working?
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
Important Information:
The vMix Forums uses cookies. By continuing to browse this site, you are agreeing to our use of cookies.
More Details
Close