Unanswered

Separate results and check if results has more than 1 value

(0) Share

Report

Posted on by Tak103

Hi:

I had pull the answers from the Excel and had append the results to the output but in using the append, it concatenated all the results into one variable. How can I separate the results so that they are not all combine into 1 string in the variable. This is needed as I need to check if there are multiple answers. If there are, I need to ask them to rephrase the question. Would appreciate any guidance on how I can separate the results that I got from looking up on the Excel and also how I can check if there are multiple answers being return.

Thanks,

All responses (2)

Answers (0)

Tak103 72 on at

Like (0)

Report

Re: Separate results and check if results has more than 1 value

Thanks Christian. How will I check if multiple rows have been returned so that if 1 row is returned, I can then provide the answer but if multiple rows are returned, then ask them if they want to refine their question? Thanks
cabata 314 Most Valuable Professional on at

Like (0)

Report

Re: Separate results and check if results has more than 1 value

hi @Tak103 what you can do is add a separator in your append like this

YOURtext,

coma is separator.

Then you can use in a compose action the expression split("Yourtext",",") using the separator. So then as result you will have separated data in an array variable