{"id":3410,"date":"2020-01-06T04:31:06","date_gmt":"2020-01-05T19:31:06","guid":{"rendered":"https:\/\/now0930.pe.kr\/wordpress\/?p=3410"},"modified":"2020-01-06T04:45:59","modified_gmt":"2020-01-05T19:45:59","slug":"qlik-%ec%a0%84-%ea%b0%92-%ec%b0%be%ea%b8%b0","status":"publish","type":"post","link":"https:\/\/now0930.pe.kr\/wordpress\/qlik-%ec%a0%84-%ea%b0%92-%ec%b0%be%ea%b8%b0\/","title":{"rendered":"Qlik \uc804 \uac12 \ucc3e\uae30"},"content":{"rendered":"\n<p>\uc18d\ub3c4, \uc2dc\uac01\uc744 \uc54c \uacbd\uc6b0, \uac00\uc18d\ub3c4\ub97c \uad6c\ud574\uc57c \ud55c\ub2e4. <a href=\"https:\/\/help.qlik.com\/ko-KR\/sense\/November2019\/Subsystems\/Hub\/Content\/Sense_Hub\/Scripting\/InterRecordFunctions\/Peek.htm\">peek<\/a> \ud568\uc218\uac00 \uba54\ubaa8\ub9ac\uc5d0 \uc800\uc7a5\ub41c \ud604\uc7ac \ud589 \ubc14\ub85c \uc804 \uac12(-1)\uc744 \ucc3e\ub294\ub2e4. \uba54\ubaa8\ub9ac\uc5d0\uc11c \ucc3e\uc73c\ubbc0\ub85c load \ud574\uc57c \ud55c\ub2e4.<\/p>\n\n\n\n<p>\ub2e4\uc74c \uc18d\ub3c4, \uc2dc\uac01 \ud14c\uc774\ube14\uc744 Sheet1 \uc5d1\uc140 \ud30c\uc77c\ub85c \uac00\uc9c0\uace0 \uc788\ub2e4.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\uc2dc\uac01\t\uc18d\ub3c4\n0.002\t10\n0.004\t10.5\n0.006\t11\n0.008\t11.5\n0.01\t12\n0.012\t12.5\n0.014\t13\n0.016\t13.5<\/pre>\n\n\n\n<p>\uc544\ub798\ub294 qlik\uc774 \uc790\ub3d9\uc73c\ub85c \ub9cc\ub4e0 \ucf54\ub4dc\uc774\ub2e4. qlik\uc744 \uc798 \uc54c\uba74 \ub354 \uae54\ub054\ud558\uac8c \uc0ac\uc6a9\ud560 \uc218 \uc788\uc73c\ub098, \uc9c0\uc800\ubd84\ud558\uc9c0\ub9cc \ub0b4 \uc2dc\uac04\uc744 \uc801\uac8c \uc0ac\uc6a9\ud55c \uc544\ub798\ub3c4 \uad1c\ucc2e\ub2e4.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">[Sheet1]:\nLOAD\n\t[\uc2dc\uac01],\n\t[\uc18d\ub3c4]\n FROM [lib:\/\/\uac00\uc18d\ub3c4\ubd84\uc11d\/\ud14c\uc2a4\ud2b8.xlsx]\n(ooxml, embedded labels, table is Sheet1);<\/pre>\n\n\n\n<p>\uc0ac\uc6a9\uc790 \uc9c0\uc815 script\ub97c \ucd94\uac00\ud55c\ub2e4. peek\ub97c \uc801\uc6a9\ud560 \uacbd\uc6b0, order by\ub97c \uba85\uc2dc\ud574\uc57c \ud55c\ub2e4. \uc5c4\ud55c \uac12\uc744 \uac16\ub294 \uacbd\uc6b0\ub3c4 \uc788\ub2e4.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\uac00\uc18d\ub3c4tmp:\n\nload\n[\uc2dc\uac01] as [\uac00\uc18d\ub3c4.\uc2dc\uac01],\n[\uc18d\ub3c4] as [\uac00\uc18d\ub3c4.\uc18d\ub3c4],\npeek([\uac00\uc18d\ub3c4.\uc18d\ub3c4]) as [\uac00\uc18d\ub3c4.\uc804\uc18d\ub3c4],\npeek([\uac00\uc18d\ub3c4.\uc2dc\uac01]) as [\uac00\uc18d\ub3c4.\uc804\uc2dc\uac01]\n\nResident [Sheet1]\norder by [\uc2dc\uac01] asc;\n\ndrop Table [Sheet1];\n\n\n\uac00\uc18d\ub3c4:\nload\n[\uac00\uc18d\ub3c4.\uc2dc\uac01],\n[\uac00\uc18d\ub3c4.\uc18d\ub3c4],\n([\uac00\uc18d\ub3c4.\uc804\uc18d\ub3c4]\/[\uac00\uc18d\ub3c4.\uc804\uc2dc\uac01]) as [\uac00\uc18d\ub3c4.\uac00\uc18d\ub3c4]\n\nResident [\uac00\uc18d\ub3c4tmp];\n\ndrop Table [\uac00\uc18d\ub3c4tmp];<\/pre>\n\n\n\n<p>\ub370\uc774\ud130 \ubdf0\ub97c \ubcf4\uba74 \ub2e4\uc74c \uadf8\ub9bc\uacfc \uac19\ub2e4.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1870\" height=\"974\" src=\"https:\/\/i1.wp.com\/now0930.pe.kr\/wordpress\/wp-content\/uploads\/2020\/01\/\ub370\uc774\ud130\ubdf0.png?fit=525%2C273&amp;ssl=1\" alt=\"\" class=\"wp-image-3411\" srcset=\"https:\/\/now0930.pe.kr\/wordpress\/wp-content\/uploads\/2020\/01\/\ub370\uc774\ud130\ubdf0.png 1870w, https:\/\/now0930.pe.kr\/wordpress\/wp-content\/uploads\/2020\/01\/\ub370\uc774\ud130\ubdf0-300x156.png 300w, https:\/\/now0930.pe.kr\/wordpress\/wp-content\/uploads\/2020\/01\/\ub370\uc774\ud130\ubdf0-1024x533.png 1024w, https:\/\/now0930.pe.kr\/wordpress\/wp-content\/uploads\/2020\/01\/\ub370\uc774\ud130\ubdf0-768x400.png 768w, https:\/\/now0930.pe.kr\/wordpress\/wp-content\/uploads\/2020\/01\/\ub370\uc774\ud130\ubdf0-1536x800.png 1536w\" sizes=\"auto, (max-width: 1870px) 100vw, 1870px\" \/><\/figure>\n\n\n\n<p>\uadf8\ub798\ud504\ub97c \ubcf4\uba74 \uc608\uc0c1\ub300\ub85c \ub098\uc628\ub2e4.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1920\" height=\"1031\" src=\"https:\/\/i0.wp.com\/now0930.pe.kr\/wordpress\/wp-content\/uploads\/2020\/01\/\uac00\uc18d\ub3c4\uadf8\ub798\ud504.png?fit=525%2C282&amp;ssl=1\" alt=\"\" class=\"wp-image-3412\" srcset=\"https:\/\/now0930.pe.kr\/wordpress\/wp-content\/uploads\/2020\/01\/\uac00\uc18d\ub3c4\uadf8\ub798\ud504.png 1920w, https:\/\/now0930.pe.kr\/wordpress\/wp-content\/uploads\/2020\/01\/\uac00\uc18d\ub3c4\uadf8\ub798\ud504-300x161.png 300w, https:\/\/now0930.pe.kr\/wordpress\/wp-content\/uploads\/2020\/01\/\uac00\uc18d\ub3c4\uadf8\ub798\ud504-1024x550.png 1024w, https:\/\/now0930.pe.kr\/wordpress\/wp-content\/uploads\/2020\/01\/\uac00\uc18d\ub3c4\uadf8\ub798\ud504-768x412.png 768w, https:\/\/now0930.pe.kr\/wordpress\/wp-content\/uploads\/2020\/01\/\uac00\uc18d\ub3c4\uadf8\ub798\ud504-1536x825.png 1536w\" sizes=\"auto, (max-width: 1920px) 100vw, 1920px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>\uc18d\ub3c4, \uc2dc\uac01\uc744 \uc54c \uacbd\uc6b0, \uac00\uc18d\ub3c4\ub97c \uad6c\ud574\uc57c \ud55c\ub2e4. peek \ud568\uc218\uac00 \uba54\ubaa8\ub9ac\uc5d0 \uc800\uc7a5\ub41c \ud604\uc7ac \ud589 \ubc14\ub85c \uc804 \uac12(-1)\uc744 \ucc3e\ub294\ub2e4. \uba54\ubaa8\ub9ac\uc5d0\uc11c \ucc3e\uc73c\ubbc0\ub85c load [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[12],"tags":[716,519,717],"class_list":["post-3410","post","type-post","status-publish","format-standard","hentry","category-12","tag-peek","tag-qlik","tag-717"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/now0930.pe.kr\/wordpress\/wp-json\/wp\/v2\/posts\/3410","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/now0930.pe.kr\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/now0930.pe.kr\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/now0930.pe.kr\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/now0930.pe.kr\/wordpress\/wp-json\/wp\/v2\/comments?post=3410"}],"version-history":[{"count":4,"href":"https:\/\/now0930.pe.kr\/wordpress\/wp-json\/wp\/v2\/posts\/3410\/revisions"}],"predecessor-version":[{"id":3416,"href":"https:\/\/now0930.pe.kr\/wordpress\/wp-json\/wp\/v2\/posts\/3410\/revisions\/3416"}],"wp:attachment":[{"href":"https:\/\/now0930.pe.kr\/wordpress\/wp-json\/wp\/v2\/media?parent=3410"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/now0930.pe.kr\/wordpress\/wp-json\/wp\/v2\/categories?post=3410"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/now0930.pe.kr\/wordpress\/wp-json\/wp\/v2\/tags?post=3410"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}