topic Re: How can I add (copy) rows according to number in a specific column to the datatable in Discussions

How can I add (copy) rows according to number in a specific column to the datatable

Christina — Thu, 08 Jun 2023 16:38:10 GMT

Hi, I have a datatable as shown below.

The column Anzahl shows the counts of column Prüfplan. I want JMP to make a row for every count so that Anzahl is always 1. I did that manually for row 1 as shown below, to clarify what I want to do. The original row has to be removed of course.

Can anybody help me, thank you!

Re: How can I add (copy) rows according to number in a specific column to the datatable

ron_horne — Tue, 07 Feb 2023 15:59:38 GMT

Hi @Christina ,

Perhaps this tool can help - Expand by Frequency.
https://community.jmp.com/t5/JMP-Add-Ins/Expand-by-Frequency-Column-Add-In/ta-p/21361

let us know if it works fo you.

Re: How can I add (copy) rows according to number in a specific column to the datatable

Jed_Campbell — Tue, 07 Feb 2023 16:07:38 GMT

The excellent Data Table Tools Add-in created by @brady_brady can do this. Once installed, you'll select the Add-Ins menu, then Data Table Tools, then Reshape Tables, then Unsummarize Rows

Re: How can I add (copy) rows according to number in a specific column to the datatable

Christina — Tue, 07 Feb 2023 16:09:43 GMT

That's what I wanted, thank you!

Re: How can I add (copy) rows according to number in a specific column to the datatable

txnelson — Tue, 07 Feb 2023 16:11:41 GMT

The

Tables=>Join

platform was designed to handle exactly what you are looing for. Also, take a look at

Tables=>Update

for another possible option.

Re: How can I add (copy) rows according to number in a specific column to the datatable

Christina — Tue, 07 Feb 2023 16:28:47 GMT

Thanks for your answer, others recommended me the JMP Add-in for expanding tables by frequency, that solved the problem.