598038_en-US

liliconcom

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

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!

Advanced Statistical ModelingMass CustomizationRe: 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. 

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.

 

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

That's what I wanted, thank 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

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.