Forum Discussion
Adding index column based on another query, issues with data types
are any of your queries set to be staged? specifically the MaxKey_Accounts query
when you stage a query it needs to be saved as a table. If you had a scalar value, like a number, simply referring to that query would yield the scalar value (Number). However, if its a table (like it was in this case because the query was staged) then you'd need to do the table navigation to reach the value that you're looking for. It could be something like QueryName[ColumnName]{0} where the 0 indicates that you just want the first row.
Number.From works against scalar values and not complex ones (like records, tables, lists and such). More info on the signature of the function below:
Hi nioj2S2
We haven’t heard from you on the last response and was just checking back to see if you got a chance to create a support ticket. If yes please provide the details here. Otherwise, will respond back with the more details and we will try to help.
Thanks
Hi Anonymous
Yes, I have been in call with support, awaiting their response after the information I provided them with.
Hi nioj2S2, would you mind checking the previous reply that I provided?
This might not require the assistance of the support team.
Copying the previous reply that I left:
are any of your queries set to be staged? specifically the MaxKey_Accounts query