Hi, I am using split text function to create line items for a list of 15 numbers separated by a comma.
For some reason, the output is repeating the 15 items five times under separate numbered arrays - see screenshot:
The problem is when I attempt to pull any of the single numbers out, it’s giving me this:
I could get there by running 15 separate formatter steps to give me the first number of each those rows (!) - but surely there must be an easier way?!
Ultimately, I want 15 numbers:
- 154
- 9
- 9
- 16
- … etc. up to 15
ideally in 1 or max 2 steps. Any ideas please?