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,

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

Sort by

cabata 314 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Tak103 72 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No