cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
%3CLINGO-SUB%20id%3D%22lingo-sub-615616%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20%E6%9B%B4%E6%96%B0%E8%A1%A8%E9%8C%AF%E8%AA%A4%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-615616%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%E4%B8%8D%E7%A2%BA%E5%AE%9A%E7%82%BA%E4%BB%80%E9%BA%BC%20Update%20%E6%9C%83%E9%80%99%E6%A8%A3%E5%81%9A%EF%BC%88%E5%8F%AF%E8%83%BD%E6%98%AF%E4%B8%80%E5%80%8B%E9%8C%AF%E8%AA%A4%EF%BC%8C%E4%B9%9F%E8%A8%B1%E5%8F%AF%E4%BB%A5%E5%98%97%E8%A9%A6%E8%81%AF%E7%B9%AB%20JMP%20%E6%94%AF%E6%8C%81%EF%BC%89%EF%BC%8C%E4%BD%86%E6%82%A8%E5%8F%AF%E4%BB%A5%E5%98%97%E8%A9%A6%E4%BD%BF%E7%94%A8%20Join%EF%BC%88%E5%AE%83%E5%B0%87%E5%89%B5%E5%BB%BA%E4%B8%80%E5%80%8B%E6%96%B0%E8%A1%A8%EF%BC%89%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22jthi_0-1679514693104.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1679514693104.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1679514693104.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1679514693104.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1679514693104.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1679514693104.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1679514693104.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1679514693104.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F51414i2202B147221D616E%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22jthi_0-1679514693104.png%22%20alt%3D%22jthi_0-1679514693104.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-615559%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%E6%9B%B4%E6%96%B0%E8%A1%A8%E9%8C%AF%E8%AA%A4%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-615559%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%E5%97%A8%20JMP%20%E7%A4%BE%E5%8D%80%EF%BC%8C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%E6%88%91%E6%AD%A3%E5%9C%A8%E5%98%97%E8%A9%A6%E6%9B%B4%E6%96%B0%E4%BE%86%E8%87%AA%E5%8F%A6%E4%B8%80%E5%80%8B%20jmp%20%E6%95%B8%E6%93%9A%E7%9A%84%E8%A1%8C%E3%80%82%3C%2FP%3E%3CP%3E%E7%95%B6%E6%88%91%E6%9B%B4%E6%96%B0%E8%A1%A8%E6%A0%BC%E6%99%82%EF%BC%8C%E4%B8%80%E4%BA%9B%E8%A1%8C%E5%80%BC%E5%9C%A8%E6%9B%B4%E6%96%B0%E5%BE%8C%E6%B6%88%E5%A4%B1%EF%BC%88%E8%A6%8B%E4%B8%8B%E9%9D%A2%E7%9A%84%E7%89%87%E6%AE%B5%EF%BC%89%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Jackie__1-1679507124849.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Jackie__1-1679507124849.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Jackie__1-1679507124849.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F51407iBDB39F909C6E8867%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Jackie__1-1679507124849.png%22%20alt%3D%22Jackie__1-1679507124849.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%E5%8E%9F%E8%A1%A8%EF%BC%9A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Jackie__2-1679507207718.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Jackie__2-1679507207718.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Jackie__2-1679507207718.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F51408i91F6BCFD571A2970%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Jackie__2-1679507207718.png%22%20alt%3D%22Jackie__2-1679507207718.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%E6%9B%B4%E6%96%B0%E5%BE%8C%EF%BC%9A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Jackie__0-1679507097463.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Jackie__0-1679507097463.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Jackie__0-1679507097463.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F51406i014F85CB5B725ABB%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Jackie__0-1679507097463.png%22%20alt%3D%22Jackie__0-1679507097463.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%E6%9C%89%E4%BB%80%E9%BA%BC%E6%84%8F%E8%A6%8B%E6%88%96%E5%BB%BA%E8%AD%B0%E5%97%8E%EF%BC%9F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-615559%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CLINGO-LABEL%3E%E8%85%B3%E6%9C%AC%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Choose Language Hide Translation Bar
Jackie_
Level VI

Update table error

Hi JMP community,

 

I'm trying to update the rows from another jmp data.

When I update the table, some of the row values disappear after updating (see snippet below)

 

Jackie__1-1679507124849.png

 

Original table : 

Jackie__2-1679507207718.png

After updaing:

Jackie__0-1679507097463.png

Any advice or suggestion?

1 REPLY 1
jthi
Super User

Re: Update table error

Not sure why Update is doing that (could be a bug, maybe try contacting JMP support), but you could try using Join instead (it will create a new table)

jthi_0-1679514693104.png

 

-Jarmo