logo

Live Production Software Forums


Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
mu71rd  
#1 Posted : Monday, November 23, 2020 7:54:13 PM(UTC)
mu71rd

Rank: Newbie

Groups: Registered
Joined: 11/21/2020(UTC)
Posts: 4
United Kingdom
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.


mu71rd  
#2 Posted : Monday, November 23, 2020 7:59:11 PM(UTC)
mu71rd

Rank: Newbie

Groups: Registered
Joined: 11/21/2020(UTC)
Posts: 4
United Kingdom
Location: Guildford

struggling to attach files for some reason...

here's links to the images and files:

Working
not working

Data as rows
Data as columns
doggy  
#3 Posted : Monday, November 23, 2020 8:23:43 PM(UTC)
doggy

Rank: Advanced Member

Groups: Registered
Joined: 12/27/2012(UTC)
Posts: 5,209
Belgium
Location: Belgium

Thanks: 291 times
Was thanked: 955 time(s) in 790 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
mu71rd  
#4 Posted : Monday, November 23, 2020 10:25:38 PM(UTC)
mu71rd

Rank: Newbie

Groups: Registered
Joined: 11/21/2020(UTC)
Posts: 4
United Kingdom
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.
Users browsing this topic
Guest (2)
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.