User Community
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Discussions

Solve problems, and share tips and tricks with other JMP users.
%3CLINGO-SUB%20id%3D%22lingo-sub-382601%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3EJMP%EB%A1%9C%20%EA%B0%80%EC%A0%B8%EC%98%AC%20%EB%95%8C%20Excel%20%ED%86%B5%ED%95%A9%20%EB%AC%B8%EC%84%9C%20%EC%9D%B4%EB%A6%84%EC%9D%84%20%EC%B0%B8%EC%A1%B0%ED%95%98%EB%8A%94%20Excel%20%EC%8B%9C%ED%8A%B8%EB%A5%BC%20%EC%96%B4%EB%96%BB%EA%B2%8C%20%EA%B0%80%EC%A0%B8%EC%98%AC%20%EC%88%98%20%EC%9E%88%EB%82%98%EC%9A%94%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-382601%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%EB%A7%A4%EB%8B%AC%20%EC%BB%B4%ED%8C%8C%EC%9D%BC%EB%90%98%EB%8A%94%20%EC%95%BD%202%EB%85%84%EC%B9%98%EC%9D%98%20Excel%20%ED%8C%8C%EC%9D%BC%EC%9D%B4%20%EB%A7%8E%EC%9D%B4%20%EC%9E%88%EC%8A%B5%EB%8B%88%EB%8B%A4.%20%EA%B0%81%20%ED%86%B5%ED%95%A9%20%EB%AC%B8%EC%84%9C%EC%9D%98%20%EC%8B%9C%ED%8A%B8%EB%A5%BC%20JMP%EB%A1%9C%20%EA%B0%80%EC%A0%B8%EC%98%A4%EA%B3%A0%20%EC%8B%B6%EC%8A%B5%EB%8B%88%EB%8B%A4.%20%EB%B6%88%ED%96%89%ED%95%98%EA%B2%8C%EB%8F%84%20%EB%82%A0%EC%A7%9C%20%ED%83%80%EC%9E%84%EC%8A%A4%ED%83%AC%ED%94%84%EB%8A%94%20%EA%B0%81%20%ED%86%B5%ED%95%A9%20%EB%AC%B8%EC%84%9C%EC%9D%98%20%EC%A0%9C%EB%AA%A9%EC%97%90%EC%84%9C%EB%A7%8C%20%EC%B0%B8%EC%A1%B0%EB%90%98%EA%B3%A0%20%EA%B0%80%EC%A0%B8%EC%98%A4%EB%A0%A4%EB%8A%94%20%EC%8B%9C%ED%8A%B8%EC%97%90%EC%84%9C%EB%8A%94%20%EC%B0%B8%EC%A1%B0%EB%90%98%EC%A7%80%20%EC%95%8A%EC%8A%B5%EB%8B%88%EB%8B%A4.%20%EC%96%B4%EC%A8%8C%EB%93%A0%20%EC%8B%9C%ED%8A%B8%EC%99%80%20%ED%95%A8%EA%BB%98%20%ED%86%B5%ED%95%A9%20%EB%AC%B8%EC%84%9C%20%EC%A0%9C%EB%AA%A9%EC%9D%84%20%EA%B0%80%EC%A0%B8%EC%98%AC%20%EC%88%98%20%EC%9E%88%EC%8A%B5%EB%8B%88%EA%B9%8C%3F%3C%2FP%3E%3CP%3E%EA%B0%90%EC%82%AC%ED%95%B4%EC%9A%94%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-382601%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CLINGO-LABEL%3E%EB%8D%B0%EC%9D%B4%ED%84%B0%20%EC%A0%91%EA%B7%BC%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-525226%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20JMP%EB%A1%9C%20%EA%B0%80%EC%A0%B8%EC%98%AC%20%EB%95%8C%20Excel%20%ED%86%B5%ED%95%A9%20%EB%AC%B8%EC%84%9C%20%EC%9D%B4%EB%A6%84%EC%9D%84%20%EC%B0%B8%EC%A1%B0%ED%95%98%EB%8A%94%20Excel%20%EC%8B%9C%ED%8A%B8%EB%A5%BC%20%EC%96%B4%EB%96%BB%EA%B2%8C%20%EA%B0%80%EC%A0%B8%EC%98%AC%20%EC%88%98%20%EC%9E%88%EB%82%98%EC%9A%94%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-525226%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%EB%82%B4%EA%B0%80%20%EC%9B%90%ED%95%98%EB%8A%94%20%EA%B2%83%EC%9D%B4%20%EB%AC%B4%EC%97%87%EC%9D%B8%EC%A7%80%20%EC%9D%B4%ED%95%B4%ED%95%9C%EB%8B%A4%EB%A9%B4%20%EC%9D%B4%EB%A5%BC%20%EC%B2%98%EB%A6%AC%ED%95%A0%20%EC%88%98%20%EC%9E%88%EB%8A%94%20JSL%20%EC%8A%A4%ED%81%AC%EB%A6%BD%ED%8A%B8%EB%A5%BC%20%ED%99%95%EC%8B%A4%ED%9E%88%20%EC%9E%91%EC%84%B1%ED%95%A0%20%EC%88%98%20%EC%9E%88%EC%8A%B5%EB%8B%88%EB%8B%A4.%20JSL%20%EC%8A%A4%ED%81%AC%EB%A6%BD%ED%8A%B8%EC%9D%98%20%EB%AA%A8%EC%96%91%EA%B3%BC%20%EC%88%98%ED%96%89%20%EC%9E%91%EC%97%85%EC%9D%80%20%EB%B3%B4%EC%9C%A0%ED%95%9C%20%EB%8D%B0%EC%9D%B4%ED%84%B0%EC%99%80%20%EC%83%9D%EC%84%B1%20%EB%B0%A9%EB%B2%95%EC%97%90%20%EB%94%B0%EB%9D%BC%20%EB%A7%8E%EC%9D%B4%20%EB%8B%AC%EB%9D%BC%EC%A7%91%EB%8B%88%EB%8B%A4.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%EC%95%84%EB%A7%88%EB%8F%84%20%EC%B5%9C%EC%86%8C%ED%95%9C%20Files%20In%20Directory()%2C%20For%20%EB%A3%A8%ED%94%84(%EB%98%90%EB%8A%94%20For%20Each%EA%B0%80%20%EB%8D%94%20%EB%82%98%EC%9D%84%20%EC%88%98%EB%8F%84%20%EC%9E%88%EC%9D%8C)%2C%20Open()%20%EB%B0%8F%20%EC%9D%BC%EB%B6%80%20%EB%AC%B8%EC%9E%90%EC%97%B4%2F%EB%8D%B0%EC%9D%B4%ED%84%B0%20%ED%85%8C%EC%9D%B4%EB%B8%94%20%EC%A1%B0%EC%9E%91%20%ED%95%A8%EC%88%98%EA%B0%80%20%ED%95%84%EC%9A%94%ED%95%A0%20%EA%B2%83%EC%9E%85%EB%8B%88%EB%8B%A4.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-525205%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20JMP%EB%A1%9C%20%EA%B0%80%EC%A0%B8%EC%98%AC%20%EB%95%8C%20Excel%20%ED%86%B5%ED%95%A9%20%EB%AC%B8%EC%84%9C%20%EC%9D%B4%EB%A6%84%EC%9D%84%20%EC%B0%B8%EC%A1%B0%ED%95%98%EB%8A%94%20Excel%20%EC%8B%9C%ED%8A%B8%EB%A5%BC%20%EC%96%B4%EB%96%BB%EA%B2%8C%20%EA%B0%80%EC%A0%B8%EC%98%AC%20%EC%88%98%20%EC%9E%88%EB%82%98%EC%9A%94%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-525205%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%EC%95%88%EB%85%95%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F5579%22%20target%3D%22_blank%22%3E%20%40Wendy_Murphrey%3C%2FA%3E%20%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%EC%99%84%EC%84%B1%EB%90%9C%20%EB%8C%80%ED%99%94%EB%A5%BC%20%EB%8B%A4%EC%8B%9C%20%EB%B6%88%EB%9F%AC%EC%99%80%EC%84%9C%20%EC%A3%84%EC%86%A1%ED%95%A9%EB%8B%88%EB%8B%A4%EB%A7%8C%2C%20%EC%84%B1%EA%B2%A9%EC%83%81%20%EB%B9%84%EC%8A%B7%ED%95%9C%20%EB%AC%B8%EC%9D%98%EA%B0%80%20%EC%9E%88%EC%8A%B5%EB%8B%88%EB%8B%A4.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFiona%EC%99%80%20%EB%A7%88%EC%B0%AC%EA%B0%80%EC%A7%80%EB%A1%9C%20%EC%A0%80%EC%97%90%EA%B2%8C%EB%8F%84%20%EB%B6%84%EC%84%9D%EC%9D%84%20%EC%9C%84%ED%95%B4%20%EB%8D%B0%EC%9D%B4%ED%84%B0%EB%A5%BC%20JMP%EB%A1%9C%20%EC%A0%84%EC%86%A1%ED%95%98%EB%8A%94%20%EC%88%98%EB%A7%8E%EC%9D%80%20Excel%20%ED%8C%8C%EC%9D%BC%EC%9D%B4%20%EC%9E%88%EC%8A%B5%EB%8B%88%EB%8B%A4.%20%EC%B5%9C%EA%B7%BC%EA%B9%8C%EC%A7%80%20%EC%A0%80%EB%8A%94%20Excel%20%ED%8C%8C%EC%9D%BC%EC%9D%84%20%EC%88%98%EB%8F%99%EC%9C%BC%EB%A1%9C%20%EC%97%B4%EA%B3%A0%20%EA%B4%80%EB%A0%A8%20%EC%A0%95%EB%B3%B4%EB%A5%BC%20JMP%20%ED%85%8C%EC%9D%B4%EB%B8%94%EC%97%90%20%EC%A7%81%EC%A0%91%20%EB%B3%B5%EC%82%AC%ED%95%98%EB%8A%94%20%EB%A7%A4%EC%9A%B0%20%EC%A4%91%EC%84%B8%EC%A0%81%EC%9D%B8%20%EB%B0%A9%EC%8B%9D%EC%9C%BC%EB%A1%9C%20%EC%9D%B4%20%EC%9E%91%EC%97%85%EC%9D%84%20%EC%88%98%ED%96%89%ED%95%B4%20%EC%99%94%EC%8A%B5%EB%8B%88%EB%8B%A4.%20%EC%9D%B4%EA%B2%83%EC%9D%B4%20%EA%B0%80%EB%8A%A5%ED%95%98%EC%A7%80%EB%A7%8C%20%EA%B0%80%EC%A0%B8%EC%98%A4%EA%B8%B0%20%EA%B8%B0%EB%8A%A5(%EA%B8%B0%EC%A1%B4%20%EB%8D%B0%EC%9D%B4%ED%84%B0%20%ED%85%8C%EC%9D%B4%EB%B8%94%EC%97%90%20%EC%B6%94%EA%B0%80%ED%95%98%EA%B8%B0%20%EC%9C%84%ED%95%9C%20%EC%97%B0%EA%B2%B0%EA%B3%BC%20%ED%95%A8%EA%BB%98)%EC%9D%B4%20%ED%9A%A8%EC%9C%A8%EC%84%B1%EC%9D%84%20%ED%96%A5%EC%83%81%EC%8B%9C%ED%82%A4%EA%B8%B0%20%EC%9C%84%ED%95%9C%20%ED%9B%A8%EC%94%AC%20%EB%8D%94%20%EB%82%98%EC%9D%80%20%EC%9E%A5%EA%B8%B0%EC%A0%81%20%EC%86%94%EB%A3%A8%EC%85%98%EC%9D%B4%EB%9D%BC%EA%B3%A0%20%EB%AF%BF%EC%8A%B5%EB%8B%88%EB%8B%A4.%3CBR%20%2F%3E%20Fiona%EC%9D%98%20%EA%B2%BD%EC%9A%B0%20%EA%B4%80%EB%A0%A8%20%EC%A0%95%EB%B3%B4%EB%8A%94%20%EA%B0%81%20%ED%86%B5%ED%95%A9%20%EB%AC%B8%EC%84%9C%EC%9D%98%20%EC%8B%9C%ED%8A%B8%204%EC%97%90%20%EC%9E%88%EC%9C%BC%EB%A9%B0%20%22%EC%A3%BC%EA%B8%B0%22%EB%9D%BC%EB%8A%94%20%EB%9D%BC%EB%B2%A8%EC%9D%B4%20%EB%B6%99%EC%96%B4%20%EC%9E%88%EC%8A%B5%EB%8B%88%EB%8B%A4.%20JMP%20%ED%85%8C%EC%9D%B4%EB%B8%94%EC%9D%84%20%EC%97%85%EB%8D%B0%EC%9D%B4%ED%8A%B8%ED%95%98%EB%A0%A4%EB%A9%B4%20%ED%95%B4%EB%8B%B9%20%ED%86%B5%ED%95%A9%20%EB%AC%B8%EC%84%9C%EB%A5%BC%204~20%EA%B0%9C%20%EC%A0%95%EB%8F%84%20%EA%B0%80%EC%A0%B8%EC%99%80%EC%95%BC%20%ED%95%A9%EB%8B%88%EB%8B%A4.%20%EA%B0%81%20%ED%86%B5%ED%95%A9%20%EB%AC%B8%EC%84%9C%EC%97%90%EB%8A%94%20%EC%9D%BC%EB%B0%98%EC%A0%81%EC%9C%BC%EB%A1%9C%208%EC%9E%90%20%EA%B8%B8%EC%9D%B4%EC%9D%98%20%EB%AC%B8%EC%9E%90%EC%97%B4%20%EC%A0%9C%EB%AA%A9%EC%9D%B4%20%EC%9E%88%EC%8A%B5%EB%8B%88%EB%8B%A4.%20%EC%9D%B4%EB%8A%94%20%ED%85%8C%EC%8A%A4%ED%8A%B8%20%EC%A4%91%EC%9D%B8%20%EA%B0%9C%EC%B2%B4%EC%97%90%20%EB%8C%80%ED%95%9C%20%EA%B3%A0%EC%9C%A0%20%EC%8B%9D%EB%B3%84%EC%9E%90%EC%9E%85%EB%8B%88%EB%8B%A4.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%EB%82%B4%20%EC%A7%88%EB%AC%B8%EC%9D%80%20%EB%8B%A4%EC%9D%8C%EA%B3%BC%20%EA%B0%99%EC%8A%B5%EB%8B%88%EB%8B%A4.%20%EA%B0%80%EC%A0%B8%EC%98%AC%20%EB%95%8C%20%EC%83%9D%EC%84%B1%EB%90%9C%20%ED%85%8C%EC%9D%B4%EB%B8%94%EC%9D%98%20%EC%9D%B4%EB%A6%84%EC%9D%84%20%EB%B0%94%EA%BE%B8%EB%8A%94%20%EA%B2%83%EC%9D%B4%20%EA%B0%80%EB%8A%A5%ED%95%A9%EB%8B%88%EA%B9%8C%3F%20%EC%98%88%EB%A5%BC%20%EB%93%A4%EC%96%B4%20%EC%A7%80%EA%B8%88%208%EA%B0%9C%EC%9D%98%20%ED%8C%8C%EC%9D%BC%EC%9D%84%20%EA%B0%80%EC%A0%B8%EC%98%A4%EB%A9%B4%20JMP%EC%97%90%EC%84%9C%20%EC%83%9D%EC%84%B1%EB%90%9C%20%ED%85%8C%EC%9D%B4%EB%B8%94%EC%9D%80%20%22cycle%22%20%22cycle%202%22%2C%20%22cycle%203%22%20%EB%93%B1%EC%9E%85%EB%8B%88%EB%8B%A4.%20.)%20%EC%9B%90%EB%B3%B8%20Excel%20%ED%86%B5%ED%95%A9%20%EB%AC%B8%EC%84%9C%EC%9D%98%20%EC%A0%9C%EB%AA%A9%EC%9D%B4%20%EB%90%98%EB%8F%84%EB%A1%9D%20%ED%95%98%EC%8B%9C%EA%B2%A0%EC%8A%B5%EB%8B%88%EA%B9%8C(%EC%9D%B4%20%EC%98%88%EC%97%90%EC%84%9C%EB%8A%94%20%22%ED%86%B5%ED%95%A9%20%EB%AC%B8%EC%84%9C%201%22%2C%20%22%ED%86%B5%ED%95%A9%20%EB%AC%B8%EC%84%9C%202%22%2C%20%22%ED%86%B5%ED%95%A9%20%EB%AC%B8%EC%84%9C%203%22%20%EB%93%B1%EC%9D%B4%20%EB%90%A8)%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%EB%8B%A4%EC%9D%8C%20%EC%A7%88%EB%AC%B8%EC%9D%80%20%EC%97%B0%EA%B2%B0%EC%97%90%20%EA%B4%80%ED%95%9C%20%EA%B2%83%EC%9E%85%EB%8B%88%EB%8B%A4.%20%ED%8A%B9%EC%A0%95%20%EC%85%80(%EC%98%88%3A%20%EA%B0%80%EC%A0%B8%EC%98%AC%20%EB%95%8C%20%ED%86%B5%ED%95%A9%20%EB%AC%B8%EC%84%9C%20%EC%A0%9C%EB%AA%A9%EC%9D%84%20%ED%8A%B9%EC%A0%95%20%EC%97%B4%EC%97%90%20%EB%B3%B5%EC%82%AC%ED%95%98%EB%8A%94%20%EC%8A%A4%ED%81%AC%EB%A6%BD%ED%8A%B8%EC%97%90%20%EC%9D%98%ED%95%B4%20%EC%83%9D%EC%84%B1%EB%90%9C%20%EC%85%80)%EC%9D%84%20%EB%B6%84%EC%84%9D%ED%95%A0%20%EC%88%98%20%EC%9E%88%EB%8A%94%20%EC%8A%A4%ED%81%AC%EB%A6%BD%ED%8A%B8%EB%A5%BC%20%EC%9E%91%EC%84%B1%ED%95%9C%20%EB%8B%A4%EC%9D%8C%20%ED%95%B4%EB%8B%B9%20%EC%85%80%20%EB%82%B4%EC%9D%98%20%EA%B0%92%EC%9D%84%20%EC%82%AC%EC%9A%A9%ED%95%98%EC%97%AC%20%EC%B6%94%EA%B0%80%ED%95%A0%20%EC%88%98%20%EC%9E%88%EC%8A%B5%EB%8B%88%EA%B9%8C%3F%20%EB%82%98%EB%A8%B8%EC%A7%80%20%EC%97%B4%EC%9D%98%20%EC%A0%95%EB%B3%B4%EB%A5%BC%20%EA%B8%B0%EC%A1%B4%20JMP%20%ED%85%8C%EC%9D%B4%EB%B8%94%EC%97%90%20%EC%B6%94%EA%B0%80%ED%95%A9%EB%8B%88%EA%B9%8C%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%EB%AA%85%ED%99%95%ED%9E%88%20%ED%95%98%EA%B8%B0%20%EC%9C%84%ED%95%B4%2C%20%EC%9D%B4%20%EA%B2%BD%EC%9A%B0%20%22A71320%22%EC%9D%B4%EB%9D%BC%EB%8A%94%20%EB%9D%BC%EB%B2%A8%EC%9D%B4%20%EB%B6%99%EC%9D%80%20%EA%B0%9C%EC%B2%B4%EB%A5%BC%20%ED%85%8C%EC%8A%A4%ED%8A%B8%ED%95%98%EA%B3%A0%20%EC%9E%88%EB%8B%A4%EA%B3%A0%20%EA%B0%80%EC%A0%95%ED%95%B4%20%EB%B3%B4%EA%B2%A0%EC%8A%B5%EB%8B%88%EB%8B%A4.%20%EC%9D%B4%20%ED%85%8C%EC%8A%A4%ED%8A%B8%20%EA%B0%9C%EC%B2%B4%EC%97%90%20%EB%8C%80%ED%95%9C%20%EB%AA%A8%EB%93%A0%20%EA%B4%80%EB%A0%A8%20%EB%8D%B0%EC%9D%B4%ED%84%B0%EB%A5%BC%20%ED%8E%B8%EC%A7%91%ED%95%9C%20%22A71320%22%EC%9D%B4%EB%9D%BC%EB%8A%94%20JMP%20%EB%8D%B0%EC%9D%B4%ED%84%B0%20%ED%85%8C%EC%9D%B4%EB%B8%94%EC%9D%B4%20%EC%9E%88%EC%8A%B5%EB%8B%88%EB%8B%A4.%20%EA%B0%81%EA%B0%81%EC%9D%98%20%EC%83%88%EB%A1%9C%EC%9A%B4%20%ED%85%8C%EC%8A%A4%ED%8A%B8%EB%8A%94%20%22A71320%22%EC%9D%B4%EB%9D%BC%EB%8A%94%20%EB%A0%88%EC%9D%B4%EB%B8%94%EC%9D%B4%20%EB%B6%99%EC%9D%80%20Excel%20%ED%8C%8C%EC%9D%BC%EC%9D%84%20%EC%83%9D%EC%84%B1%ED%95%A9%EB%8B%88%EB%8B%A4.%20%EA%B7%80%ED%95%98%EC%9D%98%20%EC%8A%A4%ED%81%AC%EB%A6%BD%ED%8A%B8%EB%A5%BC%20%EC%82%AC%EC%9A%A9%ED%95%98%EC%97%AC%20%EC%9D%B4%20%ED%8C%8C%EC%9D%BC%EC%9D%84%20%EA%B0%80%EC%A0%B8%EC%98%A4%EA%B3%A0%20%EC%8B%B6%EC%8A%B5%EB%8B%88%EB%8B%A4.%20%EC%A0%9C%EA%B0%80%20%EC%98%AC%EB%B0%94%EB%A5%B4%EA%B2%8C%20%EC%9D%B4%ED%95%B4%ED%96%88%EB%8B%A4%EB%A9%B4%20%EC%8B%9C%ED%8A%B8%204%20%22cycle%22%EC%9D%98%20%EB%AA%A8%EB%93%A0%20%EB%8D%B0%EC%9D%B4%ED%84%B0%EB%A5%BC%20%EB%B3%B5%EC%82%AC%ED%95%98%EA%B3%A0%20%22cycle%22%EC%9D%B4%EB%9D%BC%EB%8A%94%20%EB%9D%BC%EB%B2%A8%EC%9D%B4%20%EB%B6%99%EC%9D%80%20%EC%83%88%20JMP%20%ED%85%8C%EC%9D%B4%EB%B8%94%EC%9D%84%20%EC%83%9D%EC%84%B1%ED%95%9C%20%EB%8B%A4%EC%9D%8C%20%EC%9D%B4%20%EC%83%88%20%ED%85%8C%EC%9D%B4%EB%B8%94%20%EB%82%B4%EC%97%90%EC%84%9C%201%EA%B0%9C%EC%9D%98%20%EC%B1%84%EC%9B%8C%EC%A7%84%20%EC%85%80%20%22A71320%22%EC%9D%B4%20%EC%9E%88%EB%8A%94%20%EC%83%88%20%EC%97%B4%EC%9D%84%20%EC%83%9D%EC%84%B1%ED%95%A9%EB%8B%88%EB%8B%A4.%20.%20%EA%B7%B8%EB%9F%B0%20%EB%8B%A4%EC%9D%8C%20%EC%9D%B4%20%EC%85%80%20%22A71320%22%EC%9D%84%20%EB%B3%B4%EA%B3%A0%20JMP%20%EB%82%B4%EC%97%90%EC%84%9C%20%22A71320%22%EC%9D%B4%EB%9D%BC%EB%8A%94%20%EA%B8%B0%EC%A1%B4%20%ED%85%8C%EC%9D%B4%EB%B8%94%EC%9D%84%20%EC%9D%B8%EC%8B%9D%ED%95%98%EA%B3%A0%20%EC%A0%9C%EB%AA%A9%20%EC%85%80%EC%9D%84%20%EC%A0%9C%EC%99%B8%ED%95%9C%20%EB%AA%A8%EB%93%A0%20%EC%A0%95%EB%B3%B4%EB%A5%BC%20%22cycle%22%EC%97%90%EC%84%9C%20%22A71320%22%EA%B9%8C%EC%A7%80%20%EC%B6%94%EA%B0%80%ED%95%98%EB%8A%94%20%EC%8A%A4%ED%81%AC%EB%A6%BD%ED%8A%B8%EB%A5%BC%20%EC%8B%A4%ED%96%89%ED%95%98%EA%B3%A0%20%EC%8B%B6%EC%8A%B5%EB%8B%88%EB%8B%A4.%20%EC%9D%B4%EA%B2%83%EC%9D%B4%20%EA%B0%80%EB%8A%A5%ED%95%9C%EA%B0%80%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%EC%8B%9C%EA%B0%84%EC%9D%84%20%EB%82%B4%EC%96%B4%20%EC%9D%B4%20%EC%A7%88%EB%AC%B8%EC%9D%84%20%EC%9D%BD%EC%96%B4%EC%A3%BC%EC%85%94%EC%84%9C%20%EC%A7%84%EC%8B%AC%EC%9C%BC%EB%A1%9C%20%EA%B0%90%EC%82%AC%EB%93%9C%EB%A6%BD%EB%8B%88%EB%8B%A4.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%EC%98%81%EC%96%91%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-384727%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20JMP%EB%A1%9C%20%EA%B0%80%EC%A0%B8%EC%98%AC%20%EB%95%8C%20Excel%20%ED%86%B5%ED%95%A9%20%EB%AC%B8%EC%84%9C%20%EC%9D%B4%EB%A6%84%EC%9D%84%20%EC%B0%B8%EC%A1%B0%ED%95%98%EB%8A%94%20Excel%20%EC%8B%9C%ED%8A%B8%EB%A5%BC%20%EC%96%B4%EB%96%BB%EA%B2%8C%20%EA%B0%80%EC%A0%B8%EC%98%AC%20%EC%88%98%20%EC%9E%88%EB%82%98%EC%9A%94%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-384727%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%EC%97%84%EC%B2%AD%EB%82%9C!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-384696%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20JMP%EB%A1%9C%20%EA%B0%80%EC%A0%B8%EC%98%AC%20%EB%95%8C%20Excel%20%ED%86%B5%ED%95%A9%20%EB%AC%B8%EC%84%9C%20%EC%9D%B4%EB%A6%84%EC%9D%84%20%EC%B0%B8%EC%A1%B0%ED%95%98%EB%8A%94%20Excel%20%EC%8B%9C%ED%8A%B8%EB%A5%BC%20%EC%96%B4%EB%96%BB%EA%B2%8C%20%EA%B0%80%EC%A0%B8%EC%98%AC%20%EC%88%98%20%EC%9E%88%EB%82%98%EC%9A%94%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-384696%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F16121%22%20target%3D%22_blank%22%3E%40fionaweston%3C%2FA%3E%20Excel%20%EC%8B%9C%ED%8A%B8%EC%9D%98%20%ED%83%AD%20%EA%B0%80%EC%A0%B8%EC%98%A4%EA%B8%B0%20%EC%A0%9C%EC%96%B4%EA%B0%80%20JMP%20%EA%B0%9C%EC%84%A0%EC%97%90%20%EC%9C%A0%EC%9A%A9%ED%95%A0%20%EA%B2%83%20%EA%B0%99%EC%8A%B5%EB%8B%88%EB%8B%A4.%20%EC%9D%B4%20%EC%9A%94%EC%B2%AD%EC%9D%B4%20%EB%8B%A4%EC%9D%8C%20%ED%8E%98%EC%9D%B4%EC%A7%80%EC%97%90%20%EC%9E%88%EB%8A%94%20%EA%B2%83%EC%9C%BC%EB%A1%9C%20%ED%99%95%EC%9D%B8%EB%90%98%EC%97%88%EC%8A%B5%EB%8B%88%EB%8B%A4.%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2FJMP-Wish-List%2Fquot-Import-Multiple-Files-quot-improvement-suggestion%2Fidi-p%2F184615%22%20target%3D%22_self%22%3E%20JMP%20%EC%9C%84%EC%8B%9C%EB%A6%AC%EC%8A%A4%ED%8A%B8%3C%2FA%3E%20-%20%EC%A2%8B%EC%95%84%EC%9A%94%EB%A5%BC%20%EB%88%8C%EB%9F%AC%EC%A3%BC%EC%8B%9C%EB%A9%B4%20%EC%95%9E%EC%9C%BC%EB%A1%9C%20JMP%EC%97%90%EC%84%9C%20%EC%9D%B4%EB%9F%AC%ED%95%9C%20%EA%B0%9C%EC%84%A0%EC%9D%84%20%EB%B3%BC%20%EC%88%98%20%EC%9E%88%EC%9D%84%20%EA%B2%83%EC%9E%85%EB%8B%88%EB%8B%A4!%3C%2FP%3E%0A%3CP%3E%EA%B7%B8%EB%8F%99%EC%95%88%20%EC%9C%84%EC%9D%98%20JMP%20%EB%8F%99%EB%A3%8C%EB%93%A4%EC%9D%B4%20%EC%97%AC%EB%9F%AC%EB%B6%84%EC%97%90%EA%B2%8C%20%EB%8F%84%EC%9B%80%EC%9D%B4%20%EB%90%A0%20%EB%A9%8B%EC%A7%84%20JSL%20%EC%86%94%EB%A3%A8%EC%85%98%EC%9D%84%20%EC%A0%9C%EA%B3%B5%ED%96%88%EC%8A%B5%EB%8B%88%EB%8B%A4.%3C%2FP%3E%0A%3CP%3E%EC%B5%9C%EC%83%81%EC%9D%98%2C%3C%2FP%3E%0A%3CP%3E%EC%A0%9C%ED%94%84%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-383330%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20JMP%EB%A1%9C%20%EA%B0%80%EC%A0%B8%EC%98%AC%20%EB%95%8C%20Excel%20%ED%86%B5%ED%95%A9%20%EB%AC%B8%EC%84%9C%20%EC%9D%B4%EB%A6%84%EC%9D%84%20%EC%B0%B8%EC%A1%B0%ED%95%98%EB%8A%94%20Excel%20%EC%8B%9C%ED%8A%B8%EB%A5%BC%20%EC%96%B4%EB%96%BB%EA%B2%8C%20%EA%B0%80%EC%A0%B8%EC%98%AC%20%EC%88%98%20%EC%9E%88%EB%82%98%EC%9A%94%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-383330%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%EA%B3%A0%EB%A7%88%EC%9B%8C%EC%9A%94%20%EC%9B%AC%EB%94%94%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-383312%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20JMP%EB%A1%9C%20%EA%B0%80%EC%A0%B8%EC%98%AC%20%EB%95%8C%20Excel%20%ED%86%B5%ED%95%A9%20%EB%AC%B8%EC%84%9C%20%EC%9D%B4%EB%A6%84%EC%9D%84%20%EC%B0%B8%EC%A1%B0%ED%95%98%EB%8A%94%20Excel%20%EC%8B%9C%ED%8A%B8%EB%A5%BC%20%EC%96%B4%EB%96%BB%EA%B2%8C%20%EA%B0%80%EC%A0%B8%EC%98%AC%20%EC%88%98%20%EC%9E%88%EB%82%98%EC%9A%94%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-383312%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EWendy%EC%9D%98%20%EC%9D%91%EB%8B%B5%EC%9D%80%20%EC%97%AC%EB%9F%AC%20%ED%8C%8C%EC%9D%BC%20%EA%B0%80%EC%A0%B8%EC%98%A4%EA%B8%B0%EA%B0%80%20%EC%83%9D%EC%84%B1%EB%90%A0%20%EB%95%8C%20%EC%86%8C%EC%8A%A4%20%EC%97%B4%EC%9D%84%20%EC%B6%94%EA%B0%80%ED%95%98%EB%8A%94%20%EA%B0%84%EB%8B%A8%ED%95%9C%20%EB%B0%A9%EB%B2%95%EC%9D%84%20%EB%B3%B4%EC%97%AC%EC%A4%8D%EB%8B%88%EB%8B%A4.%3C%2FP%3E%0A%3CP%3EFiles%20in%20Directory()%EB%A5%BC%20%EC%82%AC%EC%9A%A9%ED%95%98%EC%97%AC%20%ED%8C%8C%EC%9D%BC%EC%9D%84%20%EA%B0%80%EC%A0%B8%EC%98%A8%20%EB%8B%A4%EC%9D%8C%20%EA%B0%84%EB%8B%A8%ED%95%9C%20For()%20%EB%A3%A8%ED%94%84%EB%A5%BC%20%EC%82%AC%EC%9A%A9%ED%95%98%EC%97%AC%20%ED%95%9C%20%ED%8C%8C%EC%9D%BC%EC%97%90%EC%84%9C%20%EB%8B%A4%EB%A5%B8%20%ED%8C%8C%EC%9D%BC%EC%9D%84%20%EC%9D%BD%EA%B3%A0%20%EA%B0%81%EA%B0%81%20Wendy%EA%B0%80%20%EC%84%A4%EB%AA%85%ED%95%9C%20%EA%B2%83%EC%B2%98%EB%9F%BC%20%EC%97%B4%EC%9D%84%20%EC%B6%94%EA%B0%80%ED%95%98%EB%8A%94%20%EA%B2%83%EC%9D%80%20%EB%A7%A4%EC%9A%B0%20%EA%B0%84%EB%8B%A8%ED%95%9C%20%EC%82%AC%EC%9A%A9%20%EB%B0%A9%EB%B2%95%EC%9E%85%EB%8B%88%EB%8B%A4.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-383303%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20JMP%EB%A1%9C%20%EA%B0%80%EC%A0%B8%EC%98%AC%20%EB%95%8C%20Excel%20%ED%86%B5%ED%95%A9%20%EB%AC%B8%EC%84%9C%20%EC%9D%B4%EB%A6%84%EC%9D%84%20%EC%B0%B8%EC%A1%B0%ED%95%98%EB%8A%94%20Excel%20%EC%8B%9C%ED%8A%B8%EB%A5%BC%20%EC%96%B4%EB%96%BB%EA%B2%8C%20%EA%B0%80%EC%A0%B8%EC%98%AC%20%EC%88%98%20%EC%9E%88%EB%82%98%EC%9A%94%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-383303%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%EC%A0%9C%ED%94%84%2C%3C%2FP%3E%3CP%3E%EB%8B%A4%EC%A4%91%20%ED%8C%8C%EC%9D%BC%20%EA%B0%80%EC%A0%B8%EC%98%A4%EA%B8%B0%EC%97%90%EB%8A%94%20%EB%82%98%EC%97%90%EA%B2%8C%20%ED%95%84%EC%9A%94%ED%95%98%EA%B3%A0%20%EA%B7%80%ED%95%98%EA%B0%80%20%EA%B0%95%EC%A1%B0%ED%95%9C%20%EA%B8%B0%EB%8A%A5%EC%9D%B4%20%EC%9E%88%EC%8A%B5%EB%8B%88%EB%8B%A4(%EA%B0%81%20%ED%86%B5%ED%95%A9%20%EB%AC%B8%EC%84%9C%EC%9D%98%20%EC%9D%B4%EB%A6%84%EC%97%90%20%EB%82%A0%EC%A7%9C(%EC%98%88%3A%20%2204%2F21%20Metrics%22)%EA%B0%80%20%ED%8F%AC%ED%95%A8%EB%90%98%EC%96%B4%20%EC%9E%88%EC%9C%BC%EB%AF%80%EB%A1%9C%20%ED%95%84%EC%9A%94%ED%95%9C%20%ED%8C%8C%EC%9D%BC%20%EC%9D%B4%EB%A6%84%20%EC%97%B4%20%EC%B6%94%EA%B0%80).%20%EA%B7%B8%EB%9F%AC%EB%82%98%20%EB%8B%A4%EC%A4%91%20%ED%8C%8C%EC%9D%BC%20%EA%B0%80%EC%A0%B8%EC%98%A4%EA%B8%B0%EB%A5%BC%20%EC%82%AC%EC%9A%A9%ED%95%98%EB%A9%B4%20%EA%B0%81%20%ED%86%B5%ED%95%A9%20%EB%AC%B8%EC%84%9C%EC%9D%98%20%EC%B2%AB%20%EB%B2%88%EC%A7%B8%20%EC%8B%9C%ED%8A%B8%EB%A7%8C%20%EB%B0%98%ED%99%98%EB%90%98%EB%A9%B0%20%EA%B0%81%20%ED%86%B5%ED%95%A9%20%EB%AC%B8%EC%84%9C%EC%9D%98%20%EC%84%B8%20%EB%B2%88%EC%A7%B8%20%EC%8B%9C%ED%8A%B8%EA%B0%80%20%ED%95%84%EC%9A%94%ED%95%A9%EB%8B%88%EB%8B%A4.%20%EB%8B%A4%EC%A4%91%20%ED%8C%8C%EC%9D%BC%20%EA%B0%80%EC%A0%B8%EC%98%A4%EA%B8%B0%EB%A5%BC%20%EC%82%AC%EC%9A%A9%ED%95%98%EC%97%AC%20%EA%B0%81%20%ED%86%B5%ED%95%A9%20%EB%AC%B8%EC%84%9C%EC%97%90%EC%84%9C%20%EC%84%B8%20%EB%B2%88%EC%A7%B8%20%EC%8B%9C%ED%8A%B8%EB%A5%BC%20%EA%B0%80%EC%A0%B8%EC%98%AC%20%EC%88%98%20%EC%9E%88%EB%8A%94%20%EB%B0%A9%EB%B2%95%EC%9D%B4%20%EC%9E%88%EC%8A%B5%EB%8B%88%EA%B9%8C%3F%20%EC%A0%9C%EA%B0%80%20%EA%B0%80%EC%A7%80%EA%B3%A0%20%EC%9E%88%EB%8A%94%20%EC%9B%8C%ED%81%AC%EB%B6%81%EC%9D%80%2020%EA%B6%8C%20%EC%A0%95%EB%8F%84%20%EB%90%A9%EB%8B%88%EB%8B%A4.%3C%2FP%3E%3CP%3E%EA%B1%B0%EA%BE%B8%EB%A1%9C%2C%3C%2FP%3E%3CP%3E%ED%8C%8C%EC%9D%BC%2F%EC%97%B4%EA%B8%B0%EB%A5%BC%20%EC%82%AC%EC%9A%A9%ED%95%98%EB%A9%B4%20%EA%B0%81%20%ED%86%B5%ED%95%A9%20%EB%AC%B8%EC%84%9C%EC%97%90%EC%84%9C%20%EC%98%AC%EB%B0%94%EB%A5%B8%20%EC%9B%8C%ED%81%AC%EC%8B%9C%ED%8A%B8(%EC%8B%9C%ED%8A%B8%203)%EB%A5%BC%20%ED%98%B8%EC%B6%9C%ED%95%A0%20%EC%88%98%20%EC%9E%88%EC%8A%B5%EB%8B%88%EB%8B%A4.%20%EC%9D%B4%EC%A0%9C%2020%EA%B0%9C%EC%9D%98%20%EC%98%AC%EB%B0%94%EB%A5%B8%20%EC%9B%8C%ED%81%AC%EC%8B%9C%ED%8A%B8%EA%B0%80%20%EC%9E%88%EC%A7%80%EB%A7%8C%20%EC%9D%B4%20%EB%B0%A9%EB%B2%95%EC%97%90%EB%8A%94%20%EC%86%8C%EC%8A%A4%20%EC%97%B4%EC%9D%84%20%EC%83%9D%EC%84%B1%ED%95%98%EB%8A%94%20%EC%98%B5%EC%85%98%EC%9D%B4%20%EC%97%86%EA%B8%B0%20%EB%95%8C%EB%AC%B8%EC%97%90%20%EC%9B%8C%ED%81%AC%EC%8B%9C%ED%8A%B8%EA%B0%80%20%EC%96%B4%EB%8A%90%20%EB%82%A0%EC%A7%9C%EC%97%90%EC%84%9C%20%EC%99%94%EB%8A%94%EC%A7%80%20%EC%95%8C%20%EC%88%98%20%EC%97%86%EC%8A%B5%EB%8B%88%EB%8B%A4.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%EA%B0%90%EC%82%AC%ED%95%B4%EC%9A%94%3C%2FP%3E%3CP%3E%ED%94%BC%EC%98%A4%EB%82%98%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-382913%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20JMP%EB%A1%9C%20%EA%B0%80%EC%A0%B8%EC%98%AC%20%EB%95%8C%20Excel%20%ED%86%B5%ED%95%A9%20%EB%AC%B8%EC%84%9C%20%EC%9D%B4%EB%A6%84%EC%9D%84%20%EC%B0%B8%EC%A1%B0%ED%95%98%EB%8A%94%20Excel%20%EC%8B%9C%ED%8A%B8%EB%A5%BC%20%EC%96%B4%EB%96%BB%EA%B2%8C%20%EA%B0%80%EC%A0%B8%EC%98%AC%20%EC%88%98%20%EC%9E%88%EB%82%98%EC%9A%94%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-382913%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F16121%22%20target%3D%22_blank%22%3E%40fionaweston%3C%2FA%3E%20%EC%9D%B4%20%EC%8B%9C%ED%8A%B8%EB%A5%BC%20%EC%96%B4%EB%96%BB%EA%B2%8C%20%EA%B0%80%EC%A0%B8%EC%98%A4%EB%82%98%EC%9A%94%3F%20%EB%8B%A4%EC%A4%91%20%ED%8C%8C%EC%9D%BC%20%EA%B0%80%EC%A0%B8%EC%98%A4%EA%B8%B0%EC%97%90%EB%8A%94%20%EC%B5%9C%EC%A2%85%20%EB%8D%B0%EC%9D%B4%ED%84%B0%20%ED%85%8C%EC%9D%B4%EB%B8%94%EC%97%90%20%EC%B6%94%EA%B0%80%EB%90%98%EB%8A%94%20%EC%97%B4%EC%97%90%20%ED%8C%8C%EC%9D%BC%20%EC%9D%B4%EB%A6%84%EC%9D%84%20%EC%B6%94%EA%B0%80%ED%95%98%EB%8A%94%20%ED%99%95%EC%9D%B8%EB%9E%80%EC%9D%B4%20%EC%9E%88%EC%8A%B5%EB%8B%88%EB%8B%A4.%20Concatenate%20%ED%94%8C%EB%9E%AB%ED%8F%BC%EC%9D%84%20%EC%82%AC%EC%9A%A9%ED%95%98%EC%97%AC%20%ED%8C%8C%EC%9D%BC%EC%9D%84%20%EC%88%98%EB%8F%99%EC%9C%BC%EB%A1%9C%20%EC%97%B0%EA%B2%B0%ED%95%98%EB%8A%94%20%EA%B2%BD%EC%9A%B0%20%EC%9C%A0%EC%82%AC%ED%95%9C%20%EB%8D%B0%EC%9D%B4%ED%84%B0%20%ED%85%8C%EC%9D%B4%EB%B8%94%20%EC%97%B4%EC%9D%84%20%EC%83%9D%EC%84%B1%ED%95%A0%20%EC%88%98%20%EC%9E%88%EC%8A%B5%EB%8B%88%EB%8B%A4.%20%EA%B0%80%EC%A0%B8%EC%98%A8%20%EA%B0%81%20%EC%8B%9C%ED%8A%B8%EC%9D%98%20%ED%8C%8C%EC%9D%BC%20%EC%9D%B4%EB%A6%84%EC%9D%80%20%EC%84%A4%EB%AA%85%EC%97%90%20%EB%94%B0%EB%9D%BC%20%ED%8C%8C%EC%9D%BC%20%ED%83%80%EC%9E%84%EC%8A%A4%ED%83%AC%ED%94%84%EB%A5%BC%20%ED%8F%AC%ED%95%A8%ED%95%B4%EC%95%BC%20%ED%95%98%EB%8A%94%20%ED%8C%8C%EC%9D%BC%20%EC%A0%9C%EB%AA%A9%EC%9D%B4%20%EB%90%A9%EB%8B%88%EB%8B%A4.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screen%20Shot%202021-05-06%20at%209.51.35%20AM.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Screen%20Shot%202021-05-06%20at%209.51.35%20AM.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Screen%20Shot%202021-05-06%20at%209.51.35%20AM.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F32655i0F159F6A60A66052%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Screen%20Shot%202021-05-06%20at%209.51.35%20AM.png%22%20alt%3D%22Screen%20Shot%202021-05-06%20at%209.51.35%20AM.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%E2%80%83%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20399px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20399px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F32653i285BFB73C91C50EF%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%E2%80%83%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-382893%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20JMP%EB%A1%9C%20%EA%B0%80%EC%A0%B8%EC%98%AC%20%EB%95%8C%20Excel%20%ED%86%B5%ED%95%A9%20%EB%AC%B8%EC%84%9C%20%EC%9D%B4%EB%A6%84%EC%9D%84%20%EC%B0%B8%EC%A1%B0%ED%95%98%EB%8A%94%20Excel%20%EC%8B%9C%ED%8A%B8%EB%A5%BC%20%EC%96%B4%EB%96%BB%EA%B2%8C%20%EA%B0%80%EC%A0%B8%EC%98%AC%20%EC%88%98%20%EC%9E%88%EB%82%98%EC%9A%94%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-382893%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%EC%95%88%EB%85%95%2C%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F16121%22%20target%3D%22_blank%22%3E%20%40fionaweston%3C%2FA%3E%20.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EJSL%EC%9D%84%20%EC%82%AC%EC%9A%A9%ED%95%98%EC%97%AC%20%EB%8D%B0%EC%9D%B4%ED%84%B0%EB%A5%BC%20%EA%B0%80%EC%A0%B8%EC%98%A8%EB%8B%A4%EA%B3%A0%20%EA%B0%80%EC%A0%95%ED%95%98%EB%A9%B4%20%EC%83%88%20%EC%97%B4%EC%9D%84%20%EC%B1%84%EC%9A%B0%EB%8A%94%20%EB%8D%B0%20%EC%82%AC%EC%9A%A9%ED%95%A0%20%EC%88%98%20%EC%9E%88%EB%8A%94%20%EB%B3%80%EC%88%98%EC%97%90%20%ED%8C%8C%EC%9D%BC%20%EC%9D%B4%EB%A6%84(%EB%98%90%EB%8A%94%20%ED%8C%8C%EC%9D%BC%20%EC%9D%B4%EB%A6%84%EC%9D%98%20%EC%9D%BC%EB%B6%80)%EC%9D%84%20%EC%A0%80%EC%9E%A5%ED%95%A0%20%EC%88%98%20%EC%9E%88%EC%8A%B5%EB%8B%88%EB%8B%A4.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3Efilepath%20%3D%20%22%24SAMPLE_IMPORT_DATA%2FTeam%20Results.xlsx%22%3B%0Afile%20%3D%20Word(%20-2%2C%20filepath%2C%20%22%2F.%22%20)%3B%3CBR%20%2F%3E%0Adt%20%3D%20Open(%0A%20filepath%2C%0A%20Worksheets(%20%22Grouped%20Team%20Results%22%20)%2C%0A%20Use%20for%20all%20sheets(%201%20)%2C%0A%20Concatenate%20Worksheets(%200%20)%2C%0A%20Create%20Concatenation%20Column(%200%20)%2C%0A%20Worksheet%20Settings(%0A%20%201%2C%0A%20%20Has%20Column%20Headers(%201%20)%2C%0A%20%20Number%20of%20Rows%20in%20Headers(%201%20)%2C%0A%20%20Headers%20Start%20on%20Row(%203%20)%2C%0A%20%20Data%20Starts%20on%20Row(%204%20)%2C%0A%20%20Data%20Starts%20on%20Column(%201%20)%2C%0A%20%20Data%20Ends%20on%20Row(%200%20)%2C%0A%20%20Data%20Ends%20on%20Column(%200%20)%2C%0A%20%20Replicated%20Spanned%20Rows(%201%20)%2C%0A%20%20Replicated%20Spanned%20Headers(%200%20)%2C%0A%20%20Suppress%20Hidden%20Rows(%201%20)%2C%0A%20%20Suppress%20Hidden%20Columns(%201%20)%2C%0A%20%20Suppress%20Empty%20Columns(%201%20)%2C%0A%20%20Treat%20as%20Hierarchy(%200%20)%2C%0A%20%20Multiple%20Series%20Stack(%200%20)%2C%0A%20%20Import%20Cell%20Colors(%200%20)%2C%0A%20%20Limit%20Column%20Detect(%200%20)%2C%0A%20%20Column%20Separator%20String(%20%22-%22%20)%0A%20)%0A)%3B%0A%20%0Adt%20%26lt%3B%26lt%3B%20New%20Column(%20%22Workbook%20Name%22%2C%20Character%2C%20Set%20Each%20Value(%20file%20)%20)%3B%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%EB%98%90%EB%8A%94%20%EC%9B%90%ED%95%98%EB%8A%94%20%EC%A0%95%EB%B3%B4%EB%A5%BC%20%EC%9E%90%EB%8F%99%EC%9C%BC%EB%A1%9C%20Excel%20%ED%8C%8C%EC%9D%BC%EC%97%90%20%EC%A7%81%EC%A0%91%20%EB%84%A3%EC%9D%84%20%EC%88%98%EB%8F%84%20%EC%9E%88%EC%8A%B5%EB%8B%88%EB%8B%A4.%EB%B3%B4%EB%8B%A4%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Finsert-the-current-excel-file-name-path-or-worksheet-in-a-cell-186833c6-c899-4912-a14c-240c2eb51e0b%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3E%20%EC%A7%80%EC%B9%A8%EC%9D%80%20%EC%9D%B4%20%EA%B2%8C%EC%8B%9C%EB%AC%BC%EC%9D%84%20%EC%B0%B8%EC%A1%B0%ED%95%98%EC%84%B8%EC%9A%94.%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%EB%8F%84%EC%9B%80%EC%9D%B4%20%EB%90%98%EA%B8%B8%20%EB%B0%94%EB%9E%8D%EB%8B%88%EB%8B%A4.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-382617%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20JMP%EB%A1%9C%20%EA%B0%80%EC%A0%B8%EC%98%AC%20%EB%95%8C%20Excel%20%ED%86%B5%ED%95%A9%20%EB%AC%B8%EC%84%9C%20%EC%9D%B4%EB%A6%84%EC%9D%84%20%EC%B0%B8%EC%A1%B0%ED%95%98%EB%8A%94%20Excel%20%EC%8B%9C%ED%8A%B8%EB%A5%BC%20%EC%96%B4%EB%96%BB%EA%B2%8C%20%EA%B0%80%EC%A0%B8%EC%98%AC%20%EC%88%98%20%EC%9E%88%EB%82%98%EC%9A%94%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-382617%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EExcel%20%ED%86%B5%ED%95%A9%20%EB%AC%B8%EC%84%9C%EB%A5%BC%20%EC%97%AC%EB%8A%94%20Open()%20%ED%95%A8%EC%88%98%EC%97%90%EB%8A%94%20%EC%97%B4%EA%B8%B0%20%EB%82%B4%EC%97%90%EC%84%9C%20%EC%84%A4%EC%A0%95%ED%95%A0%20%EC%88%98%20%EC%9E%88%EB%8A%94%20%22%EC%9B%8C%ED%81%AC%EC%8B%9C%ED%8A%B8%22%EB%9D%BC%EB%8A%94%20%EC%9A%94%EC%86%8C%EA%B0%80%20%EC%9E%88%EC%8A%B5%EB%8B%88%EB%8B%A4.%EC%95%84%EB%9E%98%EB%8A%94%20JMP%EC%97%90%20%EC%9E%85%EB%A0%A5%EB%90%98%EB%8A%94%20%EC%9B%8C%ED%81%AC%EC%8B%9C%ED%8A%B8%EC%97%90%20%EB%8C%80%ED%95%9C%20%22%EC%86%8C%EC%8A%A4%22%20%ED%95%AD%EB%AA%A9%EC%97%90%EC%84%9C%20%EA%B0%80%EC%A0%B8%EC%98%A8%20%EA%B2%83%EC%9E%85%EB%8B%88%EB%8B%A4.%EC%9D%BD%EC%9D%84%20%EC%9B%8C%ED%81%AC%EC%8B%9C%ED%8A%B8%EC%9D%98%20%EC%9D%B4%EB%A6%84%EC%9D%84%20%ED%91%9C%EC%8B%9C%ED%95%A9%EB%8B%88%EB%8B%A4.%3C%2FP%3E%0A%3CP%3E%EC%9B%8C%ED%81%AC%EC%8B%9C%ED%8A%B8(%20%22%EC%8B%9C%ED%8A%B81%22%20)%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3EOpen(%0A%20%22%24DOCUMENTS%2FDiscussion%20Group%2FData%20wrangling%20.xlsx%22%2C%0A%20Worksheets(%20%22Sheet1%22%20)%2C%0A%20Use%20for%20all%20sheets(%201%20)%2C%0A%20Concatenate%20Worksheets(%200%20)%2C%0A%20Create%20Concatenation%20Column(%200%20)%2C%0A%20Worksheet%20Settings(%0A%20%201%2C%0A%20%20Has%20Column%20Headers(%201%20)%2C%0A%20%20Number%20of%20Rows%20in%20Headers(%201%20)%2C%0A%20%20Headers%20Start%20on%20Row(%201%20)%2C%0A%20%20Data%20Starts%20on%20Row(%202%20)%2C%0A%20%20Data%20Starts%20on%20Column(%201%20)%2C%0A%20%20Data%20Ends%20on%20Row(%200%20)%2C%0A%20%20Data%20Ends%20on%20Column(%200%20)%2C%0A%20%20Replicated%20Spanned%20Rows(%201%20)%2C%0A%20%20Replicated%20Spanned%20Headers(%200%20)%2C%0A%20%20Suppress%20Hidden%20Rows(%201%20)%2C%0A%20%20Suppress%20Hidden%20Columns(%201%20)%2C%0A%20%20Suppress%20Empty%20Columns(%201%20)%2C%0A%20%20Treat%20as%20Hierarchy(%200%20)%2C%0A%20%20Multiple%20Series%20Stack(%200%20)%2C%0A%20%20Import%20Cell%20Colors(%200%20)%2C%0A%20%20Limit%20Column%20Detect(%200%20)%2C%0A%20%20Column%20Separator%20String(%20%22-%22%20)%0A%20)%0A)%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
Choose Language Hide Translation Bar
fionaweston
fionaweston
Level III

How can I import excel sheets that will reference the Excel workbook name when they are imported to JMP

Created: May 5, 2021 05:16 PM  |  Last Modified: Jun 10, 2023 4:29 PM (6291 views)

I have a bunch of excel files, about 2 years worth, which are compiled monthly. I would like to import a sheet from each workbook into JMP. Unfortunately the date timestamp is only referenced in the title of each workbook and not anywhere on the sheets that I want to import. Is there a anyway to have the workbook title imported with the sheet?

Thanks

10 REPLIES 10
fionaweston
fionaweston
Level III

Re: How can I import excel sheets that will reference the Excel workbook name when they are imported to JMP

May 13, 2021 12:42 AM (862 views)  |  Posted in reply to message from Jeff_Upton 05-12-2021
Awesome!
0 Kudos

Recommended Articles