Forum Discussion

CristianCarrion's avatar
CristianCarrion
Qrew Member
8 months 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

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
8 months ago

Great works perfectly, Thanks so much!!  :) 



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