Using Knime OpenAI and LLM Prompter Nodes for Analysing Excel Data
I have an excel data file with customer sales transactions.
I would like to build a workflow where i can upload the excel data file or simply just read the excel data file have it connected to open AI. Baesd on the excel data file upload My team can give instructions such as “tell me what are the top 10 best selling products” or “tell me what are the top 10 customers by revenue”. It will run and provide me an output of the results, just text form of the analyis will do. How can i acheive this?
So far i only able to get the nodes setup successfully until this stage only “Credentails Configuration” > “OpenAI Authenticator” > “OpenAI Chat Model Connector”.
I dragged the LLM prompter node, but i am not sure how to read the excel date, include additional details to the prompt such as tell me what are the top 10 customers by revenue" and how to display the data out. anyone can provide some advice? i am really new.