Skip to main content
Question

Iterating Excel spreadsheet into OpenAIChatGPTConnector transformer

  • August 24, 2023
  • 1 reply
  • 15 views
S

I have an Excel spreadsheet that contains 2 columns, 1st column is called Terms, 2nd column is called Definitions.

 

spreadsheet 

What I want to do is convert each flashcard pair (4 rows) into multiple choice questions via GPT3.5Turbo. The problem I'm running into is that while OpenAIChatGPTConnector  takes in the data just fine, it is only outputting 1 pair (The last row). How can I work around this?

 

workflow

    1 reply

    danminneyatsaf
    Safer
    Forum|alt.badge.img+12

    @shatterstar6457​ In the OpenAIChatGPTConnector, enable Group By and set it to Group By the Terms attribute. Since this attribute contains unique values, it will perform a separate run for each of your rows.

    image 

    Hope this helps!

    Dan

    Reply


    Helpful Members This Week

    Community Stats

    31,457
    Posts
    119,245
    Replies
    39,077
    Members

    Latest FME

    Terms & ConditionsCookie settingsAccessibility statement

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie settings
    A product of
    Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.