cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper I

## Copy to the column by the number of rows (Query Editor)

it would be possible in the query editor to do this?

 Quantity Code Code 2 result 1 1a 4/17 1a (4/17) 2 2b 4/17 2b (4/17) 1 3c 4/17 2b (4/17) 3 4d 4/17 3c (4/17) 3 5e 4/17 4d (4/17) 3 6f 4/17 4d (4/17) 4d (4/17) 5e (4/17) 5e (4/17) 5e (4/17) 6f (4/17) 6f (4/17) 6f (4/17)

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Here's one approach that might go close...

Create a function "NewList":

`(Quantity, Code, Code2) =>let NewList = List.Generate(()=>  // Start your counter at 0 and seed your list "Result" with your required values [QtyCntr = 0, Result = {Code & " (" & Code2 & ")"}],  // As you increment the counter to the limit of Quantity, build up another value set each [QtyCntr] < Quantity, each [QtyCntr=[QtyCntr]+1, Result = {Code & " (" & Code2 & ")"}],  //Return each value set (one for each Quantity) each [Result])in NewList`

Create a Table2 to reference your source Table1, calls the function for each row, and expands the lists of lists out:

```let
Source = Table1,
#"Expanded Custom" = Table.ExpandListColumn(#"Added Custom", "Custom"),
#"Expanded Custom1" = Table.ExpandListColumn(#"Expanded Custom", "Custom")
in
#"Expanded Custom1"```

Then tidy your columns as needed...

4 REPLIES 4
Microsoft Employee

Hi @skopcak,

At first, I thought this could be achieved using some Table functions(M) like Table.SelectRows, and Table.Repeat etc. And I have tried a lot, but still can't work it out(trying to studying M currently). @ImkeF, could you help us?

Regards

Anonymous
Not applicable

Here's one approach that might go close...

Create a function "NewList":

`(Quantity, Code, Code2) =>let NewList = List.Generate(()=>  // Start your counter at 0 and seed your list "Result" with your required values [QtyCntr = 0, Result = {Code & " (" & Code2 & ")"}],  // As you increment the counter to the limit of Quantity, build up another value set each [QtyCntr] < Quantity, each [QtyCntr=[QtyCntr]+1, Result = {Code & " (" & Code2 & ")"}],  //Return each value set (one for each Quantity) each [Result])in NewList`

Create a Table2 to reference your source Table1, calls the function for each row, and expands the lists of lists out:

```let
Source = Table1,
#"Expanded Custom" = Table.ExpandListColumn(#"Added Custom", "Custom"),
#"Expanded Custom1" = Table.ExpandListColumn(#"Expanded Custom", "Custom")
in
#"Expanded Custom1"```

Then tidy your columns as needed...

Helper I

Hello, Thank you for your reply, it works great. I'm very grateful.

Helper I

by bylo možné v dotazu editor, jak to udělat?

 Množství Kód kód 2 výsledek 1 1a 4/17 1a (4/17) 2 2b 4/17 2b (4/17) 1 3c 4/17 2b (4/17) 3 4d 4/17 3c (4/17) 3 5e 4/17 4d (4/17) 3 6f 4/17 4d (4/17) 4d (4/17) 5e (4/17) 5e (4/17) 5e (4/17) 6f (4/17) 6f (4/17) 6f (4/17)

Děkujeme, že jste odpověď

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.