I have a CSV Q&A source file which has issue number, description, solution and other fields.
I have done a vector query on issue description along with embedding. Semantic search is also incorporated.
Could someone help me on below issues? Any immediate help would be appreciated
Issue number is a field in csv that has value such as “ISSUE00115”. User tries to use the chat bot by prompting explain issue 00115. Chat bot is unable to identify this in the csv even though it is present
Similarly if user asks for certain category like retail and subcategory as diary, it sometimes does not consider the subcategory.
Actually your idea helped me ! I was able to achieve it using database as a source. But I am facing an issue. The response is returned in json format. How do I show it as a textual summary? Also how do I make the fields in select clause dynamic based on what the user is asking for?