Simple List to Rows

1

I have read every post and video on using formula map and split to takes a list and turn it into rows. Now matter what I try it is not working. Grateful if anyone can take a look at this simple example. Thanks so much.

2

good morning,
I’ve modified your button a bit
you had a problem with the row retrieve

1 Like
3

Hi Chris, Math,

Could one of you post a copy of the formula so it is available in the future?

Thanks
Piet

1 Like
4

“List Math” Column:

thisRow.Bulleted.Split(Character(10))
  .FormulaMap(
    CurrentValue.Trim().RegexReplace(Character(10), "")
  )

Button formula:

RawTable.Nth(1).[List Math]
  .formulaMap(
    AddRow(
      [Helper Table (Line items)],
      [Helper Table (Line items)].[Order Number],
      CurrentValue
    )
  )
1 Like
5

Thanks @Math_24 I saw the Nth command on some example but I thought that was only if it was about ordering a list. So does Nth essentially say “start with the first item on the list”? And, if it is a number, is it still needed (assuming you don’t want to change the order)? I also like the way you trimmed it. I had longer formula for trimming a bullet or a comma list but yours is more elegant. Much appreciated all.

image
image895Ă—774 42.5 KB

6

Hi Chris,

nth(list, position) will return the value in position in the list. List can be either a list of values, or a table. In the case of a table, it will return the row in position. But there is some fine print which I elaborate on in the example page Nth(list, position) below:

1 Like
7

as it says @Piet_Strydom ,
for the example I want to retrieve the first row of the table.
i use nth for take first row. I could have used first()

Target :
retrieve the list in a specific row and column

take table → first row → listMath → iteration in list for generate row

1 Like