topic Re: Vocabularies: field names with spaces in Insight Advisor

Vocabularies: field names with spaces

Marco_Imperiale — Tue, 30 Jan 2024 11:12:44 GMT

Good morning everyone,
I would like to implement a well-structured vocabulary to allow users to fully benefit from the functionalities provided by the insight advisor.
However, I am noticing that fields with spaces in their names, such as "Total Sales," "Current Year," or "% Discount," are not included in the fields list.

Where am I going wrong? I also cannot find documentation on this limitation.

Thank you for the help.

Re: Vocabularies: field names with spaces

Nasser_Bumpus — Wed, 31 Jan 2024 14:42:30 GMT

Welcome - Can you clarify where you are not seeing these fields :

1. Field list as in the field selection or business logic?

2. Is "Total Sales" or "Sales" the field name in your app?

Re: Vocabularies: field names with spaces

Marco_Imperiale — Wed, 31 Jan 2024 16:14:32 GMT

Hi and thank you:

1) Edit a sheet
2) Click on "Prepare" button and "Vocabulary"
3) In the Synonyms tab, Click on "+ Create terms"
4) Add some terms and then click on the fields combolist
5) There are no fields with spaces in their name:

Where I'm wrong?!

Re: Vocabularies: field names with spaces

Marco_Imperiale — Mon, 05 Feb 2024 08:40:10 GMT

No answers? Is it a bug or a limit?

Re: Vocabularies: field names with spaces

F_B — Mon, 05 Feb 2024 13:00:25 GMT

Hi Marco_Imperiale,

I don't have an answer for your question. I just wanted to tell you that in my experience I can find ALL the fields, including the ones with spaces. So, I guess there's not a system limitation, and you'll have to look for a problem elsewhere.

Bye

Re: Vocabularies: field names with spaces

Nagaraju_KCS — Mon, 05 Feb 2024 13:14:53 GMT

Weird, try with rename Main Category as Main_Category and check once.

if they are coming something else, but we don't have any limitations such things

Re: Vocabularies: field names with spaces

Nasser_Bumpus — Mon, 05 Feb 2024 13:53:46 GMT

Hello @Marco_Imperiale - The spaces are not a limitation. Can you double check that the fields are visible in the business logic? I will attach screenshots to reference.

Re: Vocabularies: field names with spaces

Marco_Imperiale — Wed, 07 Feb 2024 17:20:34 GMT

Hi @Nasser_Bumpus ,

thank you, it's a real mistery for me: I delete the application (it was just a test) rebuilt it from scratch and... it works... so I can't explain what happened, I'm quite sure, I rebuild all as the original (just a cupple of table and some master field), but... never in my life will know what it was 😭.

Thank you all for the answers and the support.