Azure AI services
A group of Azure services, SDKs, and APIs designed to make apps more intelligent, engaging, and discoverable.
Not able to interpret data from Excel
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(105.60000000000001, 78%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPS%3C/text%3E%3C/svg%3E)
Prasoon Srivastava
0
Reputation points
Hi All, I have created a question & answering bot with the help of Language Services, have attached 2 datasets. 1 is URL & another is a excel, i am getting the desired answers from straight questions & answers mentioned on the sheet. However, it is not able to interpret data from a table & only gives vague answers regarding that table. Can anyone help me how can i get proper answers for the data in table?
Azure AI services
{count} votes
-
romungi-MSFT 49,091 Reputation points Microsoft Employee Moderator2024-02-02T10:38:01.1933333+00:00 @Prasoon Srivastava If you are using XLS files, the data formatting should be a question & answer pair in separate columns if you are using a table format. Please see the guidelines mentioned in this document. The format should simply be like below for a table. |Question|Answer| | -------- | -------- | | Question 1 | Answer 1 | | Question 2 | Answer 2 |
If the table formatting is complex like merged or nested cells, then the extraction will not be as expected. Thanks!!
-
Prasoon Srivastava 0 Reputation points
2024-02-03T02:08:17.8566667+00:00 @romungi-MSFT thanks for your response, i have data as shown in image. i want to know that on which operating system is running on SERVERA, so would it be possible from question & answering bot or any other service has to be used, in order to achieve this?
-
romungi-MSFT 49,091 Reputation points Microsoft Employee Moderator
2024-02-05T05:21:09.5966667+00:00 @Prasoon Srivastava You will have to use the 1st and 3rd columns only in the sheet if you want to the OS details as an answer or if you want the upload to store the Q&A pair as server:OS pair. If you would like all other columns also to be returned as answer, you will have to split the excel to different sheets or CSV with question:answer pairs as question and answer columns and then upload them to the KB. I hope this helps!!
-
romungi-MSFT 49,091 Reputation points Microsoft Employee Moderator
2024-02-13T05:30:41.0233333+00:00 @Prasoon Srivastava Did you get a chance to try the above suggestion? Thanks!!
Sign in to comment
Sign in to answer