cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • New to JMP? Join us Sept. 23-24 for the Early User Edition of Discovery Summit, tailor-made for new users. Register now for free!
  • Use World Cup data to build models, explore spatial relationships, and create informative visualizations in JMP. Register. July 17, 2 pm US Eastern Time.
  • Your voice matters! Tell us how you prefer to receive JMP updates, so we can tailor our communication to your needs. Take short survey.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
Christina
Level II

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

Hi, I have a datatable as shown below. 

Christina_1-1675782988698.png

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. 

Christina_2-1675783194328.png

 

Can anybody help me, thank you!

2 ACCEPTED SOLUTIONS

Accepted Solutions
ron_horne
Super User (Alumni)

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

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.

View solution in original post

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

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

View solution in original post

5 REPLIES 5
ron_horne
Super User (Alumni)

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

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

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

Christina
Level II

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

That's what I wanted, thank you!

txnelson
Super User

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

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.

 

Jim
Christina
Level II

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

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

Recommended Articles