Forum Discussion

CristianCarrion's avatar
CristianCarrion
Qrew Member
2 years ago

How to select the first of multiple answers returned in a query.

How can I select the first result found in a query with multiple results? In the example below, the 'Correct Hauler Name' column is a query that searches for values containing: {#Column Number# .CT...
ChayceDuncan's avatar
ChayceDuncan
Qrew Captain
2 years ago

You can do a Part function and split on the ;

Formula queries return a ; delimited list, so doing the part at the first occurrence using the ; as the split will give you what you need. So in your correct hauler name: 

Part(query results value, 1, ";")



------------------------------
Chayce Duncan
------------------------------
  • CristianCarrion's avatar
    CristianCarrion
    Qrew Member
    2 years ago

    Great works perfectly, Thanks so much!!  :) 



    ------------------------------
    Cristian Carrion
    ------------------------------