Problem with specifying the ID variable names about reshape

[rgertenbach]

Thank you.
In this case the issue is that the time column in the source table has a space at the end, you could either remove it in the source table or use {"topic";"time "}.

I've been trying to publish it but needed to supply stuff I didn't have handy at the time, I hope I can be bothered to actually publish it at some point

[moleps]

Thanks for the feedback and I feel very stupid. However, after both trying the added space and removing the space I still get the same result. Were you able to reproduce the reshaped table using variable names? Best, M 11. okt. 2019 kl. 14:37 skrev Robin Gertenbach <[email protected]>: Closed #22 <#22>. — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#22?email_source=notifications&email_token=AD2RUMERQ54UT4XJJLIDIFDQOBXQBA5CNFSM4I7YHQHKYY3PNVWWK3TUL52HS4DFWZEXG43VMVCXMZLOORHG65DJMZUWGYLUNFXW5KTDN5WW2ZLOORPWSZGOUFFGVFA#event-2706008724>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AD2RUMDZJSSIJGOLFBL3G3TQOBXQBANCNFSM4I7YHQHA>.

[rgertenbach]

Ah, sorry, try using a , instead of a ;.
; Makes a new row

[rgertenbach]

Also you may need to delete, , reinsert the formula To force Sheets to update

[moleps]

OK-- The , instead of the ; worked wonders. But still specifying the variable names changed the formatting of the time column (from 9:00:00 AM to 12/30/1899 (9:00:00)) 11. okt. 2019 kl. 16:11 skrev Robin Gertenbach <[email protected]>: Also you may need to delete, , reinsert the formula To force Sheets to update — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#22?email_source=notifications&email_token=AD2RUMCRRP3H53BSMDFL5DLQOCCP7A5CNFSM4I7YHQHKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEBAD3IQ#issuecomment-541080994>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AD2RUMENHO3BA2HYTTW3S63QOCCP7ANCNFSM4I7YHQHA>.

[rgertenbach]

Not sure why that is with the referenced range but not the manual one but it's just a matter of changing the format of the cells

…

On Fri, Oct 11, 2019 at 3:17 PM moleps ***@***.***> wrote: OK-- The , instead of the ; worked wonders. But still specifying the variable names changed the formatting of the time column (from 9:00:00 AM to 12/30/1899 (9:00:00)) 11. okt. 2019 kl. 16:11 skrev Robin Gertenbach ***@***.***>: Also you may need to delete, , reinsert the formula To force Sheets to update — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub < #22?email_source=notifications&email_token=AD2RUMCRRP3H53BSMDFL5DLQOCCP7A5CNFSM4I7YHQHKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEBAD3IQ#issuecomment-541080994>, or unsubscribe < https://github.com/notifications/unsubscribe-auth/AD2RUMENHO3BA2HYTTW3S63QOCCP7ANCNFSM4I7YHQHA >. — You are receiving this because you modified the open/close state. Reply to this email directly, view it on GitHub <#22?email_source=notifications&email_token=AAPR4SR2G3NRIQWRFL5DGMLQOCDEHA5CNFSM4I7YHQHKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEBAEMHQ#issuecomment-541083166>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAPR4SSVASDNRBAE46VTIYDQOCDEHANCNFSM4I7YHQHA> .