Using File Lookup Transformation in Centerprise Data Integrator

Irfan Ahmed

January 9th, 2023

This video shows how to use file lookup transformation in Centerprise Data Integrator.

Authors:

Irfan Ahmed

Considering Astera For Your Data Management Needs?

Establish code-free connectivity with your enterprise applications, databases, and cloud applications to integrate all your data.

Let’s Connect Now!

img:is([sizes="auto" i],[sizes^="auto," i]){contain-intrinsic-size:3000px 1500px;}img.wp-smiley,img.emoji{display:inline !important;border:none !important;box-shadow:none !important;height:1em !important;width:1em !important;margin:0 .07em !important;vertical-align:-.1em !important;background:none !important;padding:0 !important;}.wp-block-rank-math-toc-block nav ol{counter-reset:item;}.wp-block-rank-math-toc-block nav ol li{display:block;}.wp-block-rank-math-toc-block nav ol li:before{content:counters(item,".") " ";counter-increment:item;}@media screen and (max-width: 640px){body:not(.fusion-builder-ui-wireframe) .fusion-no-small-visibility{display:none !important;}body:not(.fusion-builder-ui-wireframe) .sm-text-align-center{text-align:center !important;}body:not(.fusion-builder-ui-wireframe) .sm-text-align-left{text-align:left !important;}body:not(.fusion-builder-ui-wireframe) .sm-text-align-right{text-align:right !important;}body:not(.fusion-builder-ui-wireframe) .sm-mx-auto{margin-left:auto !important;margin-right:auto !important;}body:not(.fusion-builder-ui-wireframe) .sm-ml-auto{margin-left:auto !important;}body:not(.fusion-builder-ui-wireframe) .sm-mr-auto{margin-right:auto !important;}body:not(.fusion-builder-ui-wireframe) .fusion-absolute-position-small{position:absolute;top:auto;width:100%;}}@media screen and (min-width: 641px) and (max-width: 1024px){body:not(.fusion-builder-ui-wireframe) .fusion-no-medium-visibility{display:none !important;}body:not(.fusion-builder-ui-wireframe) .md-text-align-center{text-align:center !important;}body:not(.fusion-builder-ui-wireframe) .md-text-align-left{text-align:left !important;}body:not(.fusion-builder-ui-wireframe) .md-text-align-right{text-align:right !important;}body:not(.fusion-builder-ui-wireframe) .md-mx-auto{margin-left:auto !important;margin-right:auto !important;}body:not(.fusion-builder-ui-wireframe) .md-ml-auto{margin-left:auto !important;}body:not(.fusion-builder-ui-wireframe) .md-mr-auto{margin-right:auto !important;}body:not(.fusion-builder-ui-wireframe) .fusion-absolute-position-medium{position:absolute;top:auto;width:100%;}}@media screen and (min-width: 1025px){body:not(.fusion-builder-ui-wireframe) .fusion-no-large-visibility{display:none !important;}body:not(.fusion-builder-ui-wireframe) .lg-text-align-center{text-align:center !important;}body:not(.fusion-builder-ui-wireframe) .lg-text-align-left{text-align:left !important;}body:not(.fusion-builder-ui-wireframe) .lg-text-align-right{text-align:right !important;}body:not(.fusion-builder-ui-wireframe) .lg-mx-auto{margin-left:auto !important;margin-right:auto !important;}body:not(.fusion-builder-ui-wireframe) .lg-ml-auto{margin-left:auto !important;}body:not(.fusion-builder-ui-wireframe) .lg-mr-auto{margin-right:auto !important;}body:not(.fusion-builder-ui-wireframe) .fusion-absolute-position-large{position:absolute;top:auto;width:100%;}}.e-con.e-parent:nth-of-type(n+4):not(.e-lazyloaded):not(.e-no-lazyload),.e-con.e-parent:nth-of-type(n+4):not(.e-lazyloaded):not(.e-no-lazyload) *{background-image:none !important;}@media screen and (max-height: 1024px){.e-con.e-parent:nth-of-type(n+3):not(.e-lazyloaded):not(.e-no-lazyload),.e-con.e-parent:nth-of-type(n+3):not(.e-lazyloaded):not(.e-no-lazyload) *{background-image:none !important;}.e-con.e-parent:nth-of-type(n+3):not(.e-lazyloaded):not(.e-no-lazyload).nitro-lazy,.e-con.e-parent:nth-of-type(n+3):not(.e-lazyloaded):not(.e-no-lazyload) *.nitro-lazy{background-image:none !important;}}@media screen and (max-height: 640px){.e-con.e-parent:nth-of-type(n+2):not(.e-lazyloaded):not(.e-no-lazyload),.e-con.e-parent:nth-of-type(n+2):not(.e-lazyloaded):not(.e-no-lazyload) *{background-image:none !important;}.e-con.e-parent:nth-of-type(n+2):not(.e-lazyloaded):not(.e-no-lazyload).nitro-lazy,.e-con.e-parent:nth-of-type(n+2):not(.e-lazyloaded):not(.e-no-lazyload) *.nitro-lazy{background-image:none !important;}}.e-con.e-parent:nth-of-type(n+4):not(.e-lazyloaded):not(.e-no-lazyload).nitro-lazy,.e-con.e-parent:nth-of-type(n+4):not(.e-lazyloaded):not(.e-no-lazyload) *.nitro-lazy{background-image:none !important;}.elementor-329 .elementor-element.elementor-element-3ba5feb7 .eael-adv-accordion .eael-accordion-list .eael-accordion-header.active .fa-toggle{transform:rotate(180deg);}.elementor-333 .elementor-element.elementor-element-7fcc3fd3 .eael-adv-accordion .eael-accordion-list .eael-accordion-header.active .fa-toggle{transform:rotate(180deg);}.elementor-331 .elementor-element.elementor-element-44e81b8a .eael-adv-accordion .eael-accordion-list .eael-accordion-header.active .fa-toggle{transform:rotate(180deg);}.elementor-332 .elementor-element.elementor-element-1b0b7d37 .eael-adv-accordion .eael-accordion-list .eael-accordion-header.active .fa-toggle{transform:rotate(180deg);}.elementor-65 .elementor-element.elementor-element-4acfa9a > .elementor-widget-container{--e-transform-rotateZ:0deg;--e-transform-rotateX:0deg;--e-transform-perspective:1000px;--e-transform-rotateY:-14deg;}.elementor-966 .elementor-element.elementor-element-4acfa9a > .elementor-widget-container{--e-transform-rotateZ:0deg;--e-transform-rotateX:0deg;--e-transform-perspective:1000px;--e-transform-rotateY:-14deg;}.elementor-800 .elementor-element.elementor-element-4acfa9a > .elementor-widget-container{--e-transform-rotateZ:0deg;--e-transform-rotateX:0deg;--e-transform-perspective:1000px;--e-transform-rotateY:-14deg;}.elementor-615 .elementor-element.elementor-element-4acfa9a > .elementor-widget-container{--e-transform-rotateZ:0deg;--e-transform-rotateX:0deg;--e-transform-perspective:1000px;--e-transform-rotateY:-14deg;}.elementor-widget-flip-box .elementor-flip-box__front .elementor-flip-box__layer__title{font-family:var(--e-global-typography-primary-font-family),Sans-serif;font-weight:var(--e-global-typography-primary-font-weight);background-color:white;color:#005ccc;padding-top:10px;padding-bottom:10px;padding-left:15px;inline-size:min-content;padding-right:15px;border-radius:10px;}a.elementor-flip-box__button.elementor-button.elementor-size-sm{margin-left:-23px !important;}.left-recent-post a:after{content:"";}.empower_data{line-height:1.31;font-size:63px;text-align:center;color:#fff;}.professional_txt{text-align:center;font-size:36px;line-height:1.31;color:#fff;}.m20{margin:20px;}.deliver_txt{font-size:18px;line-height:25px;color:#fff;font-weight:300;font-style:normal;font-stretch:normal;letter-spacing:normal;}.demo_btn{width:177px !important;height:61px !important;height:61px !important;margin-top:30px;padding:20px 0px 0px 0px;font-family:Open Sans;font-size:18px;font-weight:600;font-style:normal;font-stretch:normal;background:#0095da !important;}.started_btn{width:177px !important;height:61px !important;height:61px !important;padding:20px 0px 0px 0px;font-family:Open Sans;font-size:18px;font-weight:600;font-style:normal;font-stretch:normal;background:#f78834 !important;}.learn_btn{width:228px !important;height:68px !important;font-family:Open Sans;font-size:18px;font-weight:600;font-style:normal;font-stretch:normal;background:#f78834 !important;padding:25px 0px 0px 0px;}.get_start_btn{padding:25px 0px 0px 0px;width:314px !important;height:66px !important;}.req_btn_demo_btn_width_height{margin:30px 30px 0px 10px;width:243px !important;height:66px;padding:20px;}.content-container >p:hover{color:#fff !important;}.home_integration .fusion-content-boxes .fusion-column{margin-bottom:0px !important;}.home_integration .fusion-content-boxes .fusion-column{margin-bottom:0px !important;}.home_integration .fusion-content-boxes .fusion-column:nth-child(2n+1){background:-moz-linear-gradient(-45deg,rgba(201,201,201,.25) 0%,rgba(201,201,201,.25) 1%,rgba(201,201,201,.25) 15%,rgba(212,212,212,.25) 33%,rgba(255,255,255,1) 100%);background:-webkit-linear-gradient(-45deg,rgba(201,201,201,.25) 0%,rgba(201,201,201,.25) 1%,rgba(201,201,201,.25) 15%,rgba(212,212,212,.25) 33%,rgba(255,255,255,1) 100%);background:linear-gradient(135deg,rgba(201,201,201,.25) 0%,rgba(201,201,201,.25) 1%,rgba(201,201,201,.25) 15%,rgba(212,212,212,.25) 33%,rgba(255,255,255,1) 100%);filter:progid:DXImageTransform.Microsoft.gradient(startColorstr="#40c9c9c9",endColorstr="#ffffff",GradientType=1);}.home_integration .fusion-content-boxes .fusion-column:nth-child(3):hover,.fusion-content-boxes .content-wrapper-background:nth-child(3):hover{background-color:#0095da !important;}.home_image_carousel .fusion-carousel .fusion-carousel-item .fusion-image-wrapper{-webkit-filter:grayscale(100%);filter:grayscale(100%);}.home_image_carousel .fusion-carousel .fusion-carousel-item .fusion-image-wrapper:hover{-webkit-filter:grayscale(100%);filter:none;}.fusion-image-hovers .hover-type-liftup{overflow:hidden !important;}.fusion-image-hovers .hover-type-liftup:hover img{transform:none !important;}.transparent_btn{width:207px !important;height:56px !important;font-family:Open Sans;border:1px solid !important;background:none !important;padding:20px 25px 0px 20px;}.viewall_btn{margin:10px 5px;}.fusion_h2{margin-top:125px !important;}.line_text{top:92px !important;position:relative !important;}.center{text-align:center;}.mt-10{margin-left:10px;}.m5{margin:5px;}.industry_solution_box .content-box-heading{text-align:left !important;font-family:Open Sans !important;}.industry_solution_box .content-container >p:hover{color:#474747 !important;}.industry_solution_box .fusion-content-boxes{margin-bottom:0px !important;}.arrow_styling{color:#0095da !important;font-size:15px !important;}.get_strt_now_btn_width_height{margin:30px 30px 0px 10px;width:316px !important;height:66px;padding:25px;}.industry_solution_heading{line-height:1.2;font-size:44px;font-weight:600;font-style:normal;color:#fff;}.financial_heading_two{font-size:20px;font-weight:300;font-style:normal;color:#fff;}.financial_services_heading{font-size:45px;font-weight:300;font-style:normal;font-stretch:normal;line-height:normal;letter-spacing:normal;text-align:left;color:#474747;}.wh-bullet-ellipse{color:#fff !important;display:inline-flex;justify-content:center;align-items:center;flex-direction:column;border-radius:50%;width:20px;height:20px;margin-top:3px;background-color:#0095da;vertical-align:top;}.wh-bullet-heading{width:88%;margin-left:8px !important;margin-bottom:0px !important;font-size:18px;font-weight:600;color:#0095da;display:inline-block;}.wh-bullet-para{margin-top:20px !important;font-size:17px;font-weight:300;color:#474747;}.bg_img_height{height:365px;}.req_demo_top{margin-top:70px;}.title_who_work{padding:55px 0px 0px 0px;font-family:Open Sans;font-size:50px;font-weight:300;font-style:normal;font-stretch:normal;line-height:normal;letter-spacing:normal;text-align:center;color:#474747;}.read_more{margin-top:65px;font-family:Open Sans;font-size:17px;font-weight:600;color:#0095da !important;background-repeat:no-repeat;background-image:url("https://cdn-ajfbi.nitrocdn.com/GuYcnotRkcKfJXshTEEKnCZTOtUwxDnm/assets/images/optimized/rev-07863b0/www.astera.com/wp-content/uploads/2018/06/read-more-arrow.png");background-position-x:right;padding-right:46px;background-position-y:center;margin-bottom:40px;}.read_more.nitro-lazy{background-image:none !important;}.bg_image_arrow{display:inline-block !important;margin-top:6px;background-repeat:no-repeat;background-size:contain;background-image:url("https://cdn-ajfbi.nitrocdn.com/GuYcnotRkcKfJXshTEEKnCZTOtUwxDnm/assets/images/optimized/rev-07863b0/www.astera.com/wp-content/uploads/2018/06/read-more-arrow.png");margin-left:10px;vertical-align:middle;width:20px;height:20px;}.bg_image_arrow.nitro-lazy{background-image:none !important;}.wcp-carousel-main-wrap .slick-track a{display:inline-block !important;margin-top:20px !important;}.wcp-carousel-main-wrap .post-style-2 .wcp-content-wrap{padding:10px 15px 10px 15px !important;}#carousel-1331 .rpc-title{font-weight:600 !important;}.wcp-carousel-main-wrap .slick-track img{margin-top:-20px;}.industry_solution_heading{font-size:44px;font-weight:600;font-style:normal;color:#fff;}.intro_Lorem{text-align:center !important;font-size:31px;font-weight:300;font-style:normal;color:#474747;}.blue_heading_boxes{color:#474747;font-size:17px;font-weight:300;text-align:left;padding:0px 0px 0px;display:block;}.paragraph_boxes_styling{display:inline-block !important;color:#0095da !important;font-size:18px !important;font-weight:600 !important;text-align:left;padding:0px 10px 30px;}.explore-more h1,.explore-more p{display:inline-block;}.explore-more{margin:-5px;text-align:left;}.c_t_a{padding-top:45px;font-size:28px;font-weight:normal;font-style:normal;font-stretch:normal;line-height:normal;letter-spacing:normal;text-align:center;color:#fff;}.c_t_a_btn{width:233px !important;height:60px;}.case_study_btn{padding:22px;font-weight:600;font-size:15px;font-family:Open Sans;font-style:normal;font-stretch:normal;background:#0095da !important;margin-top:40px;}.m-left{margin-left:-20px !important;}#padding_left{padding-left:0px !important;}.use_case_heading_banner{font-size:17px;font-weight:300;font-style:normal;font-stretch:normal;line-height:1.71;letter-spacing:normal;text-align:center;color:#474747;}.featured_resources_heading{font-size:50px;font-weight:300;font-style:normal;font-stretch:normal;line-height:normal;letter-spacing:normal;text-align:center;color:#474747;}.use_case_box .content-box-heading{text-align:right !important;}.use_case_container .fusion-content-boxes.content-boxes-icon-boxed .content-wrapper-boxed{padding:0px !important;}.use_case_box .content-box-heading{padding:5px 30px !important;color:#fff !important;background-color:#f78834;display:inline-block;}.use_case_box .heading{text-align:right !important;}.use_case_box_para{height:160px;padding:22px;font-size:19px;font-weight:normal;font-style:normal;font-stretch:normal;line-height:normal;letter-spacing:normal;text-align:center;color:#474747;}.bg_document{display:inline-block !important;background-repeat:no-repeat;background-size:contain;background-image:url("https://cdn-ajfbi.nitrocdn.com/GuYcnotRkcKfJXshTEEKnCZTOtUwxDnm/assets/images/optimized/rev-07863b0/www.astera.com/wp-content/uploads/2018/06/e-Forma-1.png");margin-left:-5px;vertical-align:middle;width:20px;height:20px;}.bg_document.nitro-lazy{background-image:none !important;}.document_heading{font-size:18px;font-weight:600;font-style:normal;font-stretch:normal;line-height:1.61;letter-spacing:normal;text-align:center;color:#114885;border-bottom:1px solid;}.block{display:block;}.edi_white_box .content-box-heading{text-align:center !important;font-family:Open Sans !important;}.edi_white_box .content-container >p:hover{color:#474747 !important;}.edi_white_box .fusion-content-boxes{margin-bottom:0px !important;}.data_integration_with_img{font-size:42px;line-height:47px;text-align:left;font-weight:300;color:#474747;}@media (max-width:480px){.data_integration{font-size:33px;line-height:47px;text-align:left;font-weight:300;margin-top:150px !important;color:#474747;}.data_integration_with_img{font-size:30px;line-height:47px;text-align:left;font-weight:300;color:#474747;}.block{display:initial !important;}.intro_Lorem{margin-right:10px !important;margin-left:10px !important;font-size:17px;}.industry_solution_heading{font-size:42px;}.case_study_btn{margin-top:0px !important;}.c_t_a{font-size:25px;}.salesforce_banner_heading{font-size:36px;}}@media (max-width: 768px){.viewall_btn{margin:10px 0px;}}@media only screen and (max-width: 800px){.industry_solution_box .fusion-content-boxes.content-boxes-icon-boxed .content-box-column,.fusion-content-boxes.content-boxes-icon-on-top .content-box-column{margin-bottom:55px;width:80%;margin:55px auto;margin-top:0px;}}form.wpcf7-form.sent .fusion-slider-loading{display:none !important;}.wpcf7-form .wpcf7-mail-sent-ok{text-transform:inherit;}.applynow-form-container .field-container .field.file-upload .wpcf7-form-control-wrap.resume{display:inline-block;overflow:hidden;position:absolute;left:309px;top:30px;text-align:right;}.applynow-form-container .field-container .field input[type=file]{margin-left:-130px;display:block;font-size:1vw;color:#c1c1c1;font-family:Open Sans;font-weight:300;text-align:right;width:299px;text-indent:-150px;}.applynow-form-container .field-container .field.file-upload br{display:none;}.applynow-form-container .field-container .field.file-upload{text-align:center;}.applynow-form-container .field-container .field.file-upload>label{position:static;display:inline-block;width:289px;height:80px;margin-top:40px;}@media screen and (max-width: 768px){.applynow-form-container .field-container .field.file-upload .wpcf7-form-control-wrap.resume{display:block;clear:both;position:static;margin-top:-50px;}.applynow-form-container .field-container .field input[type=file]{margin-left:-100px;}}@media screen and (min-width: 769px) and (max-width: 800px){.applynow-form-container .field-container .field.file-upload .wpcf7-form-control-wrap.resume{position:absolute;left:370px;}.applynow-form-container .field-container .field input[type=file]{margin-left:-80px;}}@media screen and (min-width: 801px){.applynow-form-container .field-container .field.file-upload .wpcf7-form-control-wrap.resume{top:16px;left:271px;}.applynow-form-container .field-container .field input[type=file]{margin-left:-70px;}}@media screen and (min-width: 1168px){.applynow-form-container .field-container .field.file-upload .wpcf7-form-control-wrap.resume{top:26px;left:276px;}.applynow-form-container .field-container .field input[type=file]{margin-left:-70px;}}@media only screen and (max-width: 800px){.page-id-345 .applynow-form-container .fusion-column{}.applynow-form-container.slim .field-container .field.file-upload{margin:0;}.page-id-345 .applynow-form-container .field-container .field.file-upload>label{line-height:16.19vw !important;}}@media only screen and (max-width: 640px){.page-id-345 .applynow-form-container .fusion-column{}.applynow-form-container.slim .field-container .field.file-upload{margin:0;width:33%;}.page-id-345 .applynow-form-container .field-container .field.file-upload>label{line-height:21.19vw !important;}}@media only screen and (max-width: 425px){.page-id-345 .applynow-form-container .fusion-column{}.applynow-form-container.slim .field-container .field.file-upload{margin:0;width:94%;}.page-id-345 .applynow-form-container .field-container .field.file-upload>label{line-height:31.19vw !important;}}@media only screen and (max-width: 375px){.page-id-345 .applynow-form-container .fusion-column{}.applynow-form-container.slim .field-container .field.file-upload{margin:0;width:97%;}.page-id-345 .applynow-form-container .field-container .field.file-upload>label{line-height:36.19vw !important;}}@media only screen and (min-width: 426px) and (max-width: 480px){.page-id-345 .applynow-form-container .fusion-column{}.applynow-form-container.slim .field-container .field.file-upload{margin:0;width:97%;}.page-id-345 .applynow-form-container .field-container .field.file-upload>label{line-height:28.19vw !important;}}.page-id-345 .applynow-form-container .field-container .field.file-upload>label{margin-top:0;line-height:7 !important;}.alertmsg div.wpcf7-response-output{margin-top:0;margin-bottom:2em;margin-right:2em;margin-left:2em;}.alertmsg span.fusion-alert-content{font-weight:600;}.fusion-icon-googleplus{display:none !important;}@media only screen and (max-width: 1200px){.single-career #main{padding-left:15px !important;padding-right:15px !important;}.single-career p.industry_solution_heading{padding:0 30px !important;}}.page-id-11371 .wcp-post-contents.rpc-content{min-height:136px;}.applynow-form-container .field-container .field.file-upload>label{top:0 !important;left:0 !important;}.wpcf7-form .wpcf7-mail-sent-ok span.alert-icon{display:none;}.fusion-alert-content-wrapper i.fa-lg.fa.fa-check-circle{margin-right:5px;}.fusion-alert-content-wrapper span.fusion-alert-content{text-transform:none;}.blue-strip-container .blue-strip .strip-button-container .strip-button:hover{color:#0095da !important;}.fusion-fullwidth.fullwidth-box.blue-strip-container.industry-solution-blue-strip-container.mt-30.nonhundred-percent-fullwidth.non-hundred-percent-height-scrolling +p{margin:0;}#wpls-logo-showcase-slider-1 .wp-post-image{visibility:visible !important;opacity:.6;}#wpls-logo-showcase-slider-1 .wp-post-image:hover{opacity:1;}.width-100 .nonhundred-percent-fullwidth +p{margin:0;}.single .category-edi-transaction-set .fusion-sharing-box,.category-edi-transaction-set .fusion-post-title-meta-wrap{display:none;}.fusion-author .fusion-author-title,.fusion-header-tagline,.fusion-modal .modal-title,.fusion-modal h3,.fusion-pricing-table .pricing-row,.fusion-pricing-table .title-row,.fusion-title h3,.fusion-widget-area h3,.main-flex .slide-content h3,.post-content h3,.project-content h3,.sidebar .widget h3{font-family:Open Sans !important;}@media screen and (max-width: 1150px){.parent-pageid-12 .main-menu-banner{min-height:500px;}}.parent-pageid-12 .req_btn_demo_btn_width_height{margin:30px 0 0;}.parent-pageid-12{overflow-x:hidden;}.parent-pageid-12 .fusion-imageframe,.wpsisac-slick-slider.design-4 .slick-image-slide img{width:100%;}@media screen and (max-width: 800px){.resource-search-container .fusion-columns .fusion-column.col-sm-6{width:100% !important;}}@media screen and (min-width: 641px) and (max-width: 800px){.page-id-344 .fusion-layout-column:first-child{margin-right:4% !important;}}@media screen and (max-width: 800px){.career-card{min-height:inherit !important;padding-bottom:25px;}}.post-type-archive-news .dl-blog-compact-list .dl-post{margin:15px 0 15px;}.post-type-archive-news .dl-blog-compact-list{padding-left:15px;padding-right:15px;}.slide-wrap.wp-medium-12.wpcolumns .slider-content-right.wp-medium-5.wpcolumns{display:none;}.slide-wrap.wp-medium-12.wpcolumns .slider-content-left.wp-medium-7.wpcolumns{width:100%;}.slide-wrap.wp-medium-12.wpcolumns .slider-content-left.wp-medium-7.wpcolumns img.img-responsive,.slide-wrap.wp-medium-12.wpcolumns .slider-content-left.wp-medium-7.wpcolumns span{width:100%;}@media screen and (min-width: 801px){.social-links-footer{padding-right:136px;}iframe#launcher{bottom:15px !important;}}ul#menu-pricing a:before{content:none;}body ul#menu-pricing li{padding:0;}ul#menu-pricing a,ul#menu-pricing a:hover{font-size:14px;font-weight:400;color:#575757;}section#nav_menu-2 h4.widget-title{margin-bottom:0;line-height:1.4;}@media (max-width: 800px){section#nav_menu-2 *{text-align:center;}}ul#menu-pricing .current-menu-item a{color:#646464 !important;font-weight:700;}body .applynow-form-container .field-container .field.filename{font-size:13px !important;width:84% !important;margin-left:8% !important;margin-right:8% !important;margin-bottom:0 !important;line-height:1 !important;text-indent:0 !important;float:none !important;clear:both !important;height:auto !important;}body .applynow-form-container .field-container.applynow-upload{display:block !important;}body .applynow-form-container .field-container .field.file-upload{width:84% !important;margin-left:8% !important;margin-right:8% !important;margin-bottom:11px !important;position:relative !important;}body .applynow-form-container .field-container .field.file-upload > label{}body .applynow-form-container .field-container .field.file-upload .wpcf7-form-control-wrap.resume{margin:0 !important;}.rmft{position:absolute;bottom:5.35%;left:0;}.rmlm{position:absolute;bottom:4.5%;left:0;}.search .dl-header{max-width:inherit !important;}.search .dl-header .dl-nav-container{display:inherit !important;}.search .fusion-fullwidth{background:#fff;padding:0;}.search #main .fusion-row,.search #slidingbar-area .fusion-row,.search .fusion-footer-copyright-area .fusion-row,.search .fusion-footer-widget-area .fusion-row,.search .fusion-page-title-row,.search .tfs-slider .slide-content-container .slide-content{max-width:1100px !important;}.search .fusion-footer{display:block !important;}.search .fusion-footer-widget-area .fusion-row{max-width:100% !important;}.search .fusion-footer-copyright-area .fusion-row{max-width:100% !important;}.search input[type="text"],.search input[type="email"],.search input[type="url"],.search input[type="password"],.search input[type="search"],.search input[type="number"],.search input[type="tel"],.search input[type="range"],.search input[type="date"],.search input[type="month"],.search input[type="week"],.search input[type="time"],.search input[type="datetime"],.search input[type="datetime-local"],.search input[type="color"],.search textarea,.search .hbspt-form .field select{padding:2px 10px !important;}.search .dl-header .dl-main-menu>.dl-menu>li>.sub-menu{z-index:99;}.single-tabcont .inner-tab-cont .resources-badge p{color:#fff !important;background:#005ccc !important;}.single-tabcont .inner-tab-cont a.read-more-blog{display:none;}.ekit-wid-con .ekit_testimonial_style_2{background-color:#eff5ff !important;}.wpcf7-captchar,.wpcf7-form .wpcf7-date,.wpcf7-form .wpcf7-number,.wpcf7-form .wpcf7-quiz,.wpcf7-form .wpcf7-select,.wpcf7-form .wpcf7-text{width:320px !important;height:40px !important;top:6826px !important;left:659px !important;gap:0px !important;border-radius:11px 11px 11px 11px !important;border:1px 0px 0px 0px !important;opacity:0px !important;color:#aaadb4 !important;}.wpcf7-form textarea{border-radius:11px 11px 11px 11px !important;}.wpcf7-form input[type="submit"],.wpcf7-submit:hover{background:#005ccc !important;border-radius:6px 6px 6px 6px !important;}main#main{padding-left:0 !important;padding-right:0 !important;}.blog-landing-header{background-color:#f6f8fa;padding:29px 0;}.blog-landing-header h5{color:#616161;font-family:Open Sans;font-size:24px !important;font-style:normal;font-weight:700 !important;line-height:normal;letter-spacing:-.48px;margin:0 !important;}.blog-landing-header p{margin:5px 0;text-align:right;}.blog-landing-header p,.blog-landing-header p a{color:grey;font-family:Open Sans;font-size:16px;font-style:normal;font-weight:400;line-height:normal;letter-spacing:-.32px;}.blog-content-section .blog-featured-img img{border-radius:8px;}.blog-content-section h1.blog-main-title{font-family:Open Sans !important;font-size:32px;font-weight:700;line-height:40px;letter-spacing:-.02em;text-align:left;color:#0e0e0e;margin:50px 0 30px !important;}.blog-content-section .author-with-date{margin:10px 0 30px;}.blog-content-section .author-with-date .author-wrapper .author-avatar{width:38px;border-radius:50%;height:38px;overflow:hidden;}.blog-content-section .author-with-date .author-wrapper .author-avatar{width:38px;border-radius:50%;height:38px;overflow:hidden;}.blog-content-section .author-with-date>div{display:inline-flex;vertical-align:middle;align-items:center;}.blog-content-section .author-with-date .author-wrapper .author-details{margin:-2px 40px 0 10px;}.blog-content-section .author-with-date .author-wrapper .author-details a{font-family:Open Sans !important;font-size:16px;font-weight:400;letter-spacing:-.02em;text-align:left;color:#7a7a7a;}.blog-content-section .author-with-date .author-wrapper .author-details p{font-family:Open Sans;font-size:12px;font-weight:400;line-height:14px;letter-spacing:-.02em;text-align:left;color:#a4a4a4;margin:0;}.blog-content-section .author-with-date .publish-date{font-family:Open Sans;font-size:16px;font-weight:400;line-height:22px;letter-spacing:-.02em;color:#7a7a7a;}.blog-content-section .author-with-date .publish-date .fa{margin-right:10px;font-size:24px;color:#494949;margin-top:-2px;}.blog-content-section .blog-content ol li,.blog-content-section .blog-content p,.blog-content-section .blog-content ul li{color:#535353 !important;font-family:Open Sans;font-size:16px;font-style:normal;font-weight:400;line-height:24px;}.blog-content-section .blog-content h2{color:#01348d !important;font-family:Open Sans !important;font-size:24px !important;font-style:normal;font-weight:700 !important;line-height:32px;margin-top:40px !important;margin-bottom:20px !important;}.blog-content-section .blog-content h3{color:#01348d !important;font-family:Open Sans !important;font-size:20px !important;font-style:normal;font-weight:600 !important;line-height:25px;}.blog-content-section .blog-content ul{padding-left:20px;}.blog-content-section .blog-sticky-sidebar.fixed{width:262px;}.blog-content-section .blog-sticky-sidebar .toc-heading{color:#656567;font-family:Open Sans;font-size:16px;font-style:normal;font-weight:600;line-height:normal;letter-spacing:-.32px;padding:0 0 15px 10px;}.blog-content-section .blog-sticky-sidebar ul.toc-listing li{border:0;padding:0 0 5px;}.blog-content-section .blog-sticky-sidebar ul.toc-listing li a{color:#999;font-family:Open Sans;font-size:14px;font-style:normal;font-weight:600;line-height:normal;letter-spacing:-.32px;border:0;border-radius:6px;padding:4px 10px;margin-right:5px;display:-webkit-box;-webkit-line-clamp:1;-webkit-box-orient:vertical;overflow:hidden;}.blog-content-section .blog-sticky-sidebar ul.toc-listing li a.active,.blog-content-section .blog-sticky-sidebar ul.toc-listing li a:hover{background-color:#f8f9fc;color:#f78620;}.blog-content-section .blog-sticky-sidebar .toc-wrapper ul.toc-listing{max-height:25vh;overflow-y:auto;margin-bottom:30px;}.blog-content-section .blog-sticky-sidebar ul.toc-listing{margin-bottom:0;}.blog-sidebar-cta-with-form{position:relative;z-index:1;}.blog-sidebar-cta h5 span{color:#1b5da6;}.blog-sidebar-cta{border-radius:9px;background:#f8f9fc;padding:10px 10px 13px;}.blog-sidebar-cta img{width:100%;height:100%;}.blog-sidebar-cta h5{color:#1d1b1b;font-family:Open Sans;font-size:18px !important;font-style:normal;font-weight:700 !important;line-height:24px;letter-spacing:-.36px;margin:20px 5px 0 !important;}.blog-sidebar-cta p{color:rgba(0,0,0,.62);font-family:Open Sans;font-size:14px;font-style:normal;font-weight:400;line-height:20px;letter-spacing:-.28px;margin:13px 5px 30px;}.blog-sidebar-cta .sidebar-cta a{border-radius:6px;background-color:#ff8500;color:#fff;font-family:Open Sans;font-size:16px;font-style:normal;font-weight:600;line-height:normal;letter-spacing:-.32px;display:block;padding:8.4px 15px;text-align:center;cursor:pointer;border:1px solid #ff8500;transition:all .3s;}.blog-sidebar-cta .sidebar-cta a:hover,.blog-sidebar-hubspot-form .hbspt-form input[type=submit]:hover{color:#ff8500 !important;background:0 0;}.blog-sidebar-hubspot-form{position:absolute;top:0;left:0;width:100%;background-color:#f8f9fc;padding:10px 10px 13px;border-radius:9px;z-index:-1;}.blog-sidebar-hubspot-form .hbspt-form form{padding:0;}.blog-sidebar-hubspot-form .hbspt-form .hs-form-field{margin-bottom:10px;}.hbspt-form label.hs-error-msg{font-weight:400;}.blog-sidebar-hubspot-form input[type=email],.blog-sidebar-hubspot-form input[type=tel],.blog-sidebar-hubspot-form input[type=text],.blog-sidebar-hubspot-form input[type=number]{border-width:0 0 1px 0;border-color:#c5c5c5;width:100%;background:0 0;padding:12px 10px !important;font-size:15px;color:#000 !important;height:auto;}.blog-sidebar-hubspot-form .hbspt-form select{width:100%;background:transparent;border-width:0px 0px 1px 0px;height:45px !important;color:#000;}.blog-sidebar-hubspot-form .hbspt-form input[type=submit]{border-radius:6px;background-color:#ff8500;color:#fff;font-family:Open Sans;font-size:16px;font-style:normal;font-weight:600 !important;line-height:normal;letter-spacing:-.32px;display:block;padding:8.4px 15px;text-align:center;cursor:pointer;border:1px solid #ff8500 !important;}.blog-sidebar-hubspot-form .submitted-message.hs-main-font-element{background-image:linear-gradient(#1a5bbd,#4281da);margin:-10px;border-radius:6px;padding:55px 10px;text-align:center;color:#fff;font-family:"Open Sans" !important;}.related-article-wrapper{padding:60px 0 100px;}.related-article-wrapper h5{color:rgba(109,109,109,.5);text-align:center;font-family:Open Sans;font-size:14px !important;font-style:normal;font-weight:700 !important;line-height:normal;text-transform:uppercase;margin-bottom:40px;}.related-article-content{border-radius:8px;border:1px solid #ebebeb;background:#fff;overflow:hidden;padding-bottom:20px;}.related-article-content img{height:168px;}.related-article-content h6{margin:30px 10px 0 !important;display:-webkit-box;-webkit-line-clamp:2;-webkit-box-orient:vertical;overflow:hidden;line-height:25px;min-height:51.2px;}.related-article-content h6 a{color:#124591;font-family:Open Sans;font-size:18px;font-style:normal;font-weight:700;line-height:normal;letter-spacing:-.36px;}.related-article-content .related-content{padding:20px 0 55px;}.related-article-content .related-content p{overflow:hidden;overflow:hidden;color:rgba(0,0,0,.6);font-family:Open Sans;font-size:16px;font-style:normal;font-weight:400;line-height:normal;letter-spacing:-.32px;margin:0 10px;display:-webkit-box;-webkit-line-clamp:2;-webkit-box-orient:vertical;}.related-article-content .read-more a{color:#01348d;font-family:Open Sans;font-size:16px;font-style:normal;font-weight:700;line-height:normal;letter-spacing:-.32px;margin:0 10px;display:inline-block;transition:all .3s;border:1px solid transparent;border-radius:8px;padding:4px 0;}.related-article-content .read-more a:hover{border-color:#01348d;padding:4px 10px;}.blog-bottom-cta-wrapper{background-color:#f5f7f9;position:relative;z-index:1;padding:58.5px 0;}.blog-bottom-cta-wrapper:before{content:"";position:absolute;width:551px;height:432px;background-image:url("https://cdn-ajfbi.nitrocdn.com/GuYcnotRkcKfJXshTEEKnCZTOtUwxDnm/assets/images/source/rev-07863b0/www.astera.com/wp-content/uploads/2023/12/Group.svg");right:0;top:0;z-index:-1;}.blog-bottom-cta-wrapper h6{color:#204c9b;font-family:Open Sans;font-size:36.766px !important;font-style:normal;font-weight:700 !important;line-height:38px;margin:20px 0 0 !important;max-width:535px;}.blog-bottom-cta-wrapper p{color:#484848;font-family:Inter;font-size:19.875px;font-style:normal;font-weight:400;line-height:normal;max-width:500px;margin:25px 0 30px;}.blog-bottom-cta-wrapper a.lets-connect{color:#fff;font-family:Inter;font-size:15.235px;font-style:normal;font-weight:400;line-height:normal;background-color:#ff8500;padding:10px 20px;border-radius:6px;border:1px solid #ff8500;transition:all .3s;display:inline-block;}.blog-bottom-cta-wrapper a.lets-connect:hover{color:#ff8500 !important;background:0 0;}.cta-dark > .left-ctaall > p,.cta-dark > .left-ctaall > h3{color:#fff !important;}.blog-content-section .blog-sticky-sidebar .toc-wrapper ul.toc-listing::-webkit-scrollbar{width:6px;}.blog-content-section .blog-sticky-sidebar .toc-wrapper ul.toc-listing::-webkit-scrollbar-track{border-radius:16px;background:#f2f2f2;}.blog-content-section .blog-sticky-sidebar .toc-wrapper ul.toc-listing::-webkit-scrollbar-thumb{border-radius:16px;background:#00358e;}.blog-content-section .blog-sticky-sidebar .toc-wrapper ul.toc-listing::-webkit-scrollbar-thumb:hover{background:#00358e;}.next-popup{background:#f8f9fc;width:222px;position:fixed;right:0;top:250px;padding:30px;border-top-left-radius:10px;border-bottom-left-radius:10px;height:177px;transition:width .5s ease;display:none;animation:slideInFromRight 1s ease-out 0s 1 normal both running;z-index:9999;}.closed{width:50px;right:-40px;}.left-popup h3{color:#000;font-size:20px;font-weight:600;margin:0;line-height:28px;}.left-popup p{font-size:14px;font-weight:400;line-height:20px;}.left-popup a{color:#01348d;font-size:14px;font-weight:600;align-items:center;transition:.5s;display:inline-flex;}.left-popup a:hover{padding:2px 6px;border:1px solid #01348d;border-radius:3px;}.left-popup a i{margin-left:10px;display:flex;}.close-nextblog{position:absolute;width:30px;height:30px;background:#f1f1f1;display:flex;align-items:center;justify-content:center;border-radius:40px;left:-10px;transform:translateY(-50%);top:50%;cursor:pointer;z-index:9999;transition:.8s;}.close-nextblog:hover{background:rgba(228,226,226,.86);}.next-popup:after{content:"";background:#ff8500;width:5px;height:100%;position:absolute;top:0;right:0;}.next-popup.closed:after{right:38px;}.blog-content-section .blog-featured-img img{width:100%;height:100%;}@keyframes slideInFromRight{0%{transform:translateX(100%);}100%{transform:translateX(0);}}@media (max-width:991px){.sm-hidden{display:none;}.related-article-content img{height:125px;}.related-article-content .related-content{padding:20px 0 30px;}.blog-landing-header h5,.blog-landing-header p{text-align:center;}}@media (max-width:800px){.related-article-content{max-width:330px;margin:20px auto;}}@media (max-width:640px){.blog-bottom-cta-wrapper h6{font-size:30px !important;}.blog-bottom-cta-wrapper p{font-size:18px;}}@media (max-width:480px){.blog-content-section h1.blog-main-title{font-size:27px !important;}.blog-bottom-cta-wrapper h6{font-size:24px !important;line-height:30px;}.blog-bottom-cta-wrapper p{font-size:16px;}.blog-content-section .author-with-date .publish-date{margin-top:17px;margin-left:10px;}.blog-content-section .author-with-date>div{display:block;}.blog-content-section .author-with-date .author-wrapper .author-avatar{display:table-cell;float:left;margin-right:15px;}.blog-content-section .author-with-date .author-wrapper .author-details{margin:0;}}.wp-block-audio :where(figcaption){color:#555;font-size:13px;text-align:center;}.is-dark-theme .wp-block-audio :where(figcaption){color:rgba(255,255,255,.65);}.wp-block-audio{margin:0 0 1em;}.wp-block-code{border:1px solid #ccc;border-radius:4px;font-family:Menlo,Consolas,monaco,monospace;padding:.8em 1em;}.wp-block-embed :where(figcaption){color:#555;font-size:13px;text-align:center;}.is-dark-theme .wp-block-embed :where(figcaption){color:rgba(255,255,255,.65);}.wp-block-embed{margin:0 0 1em;}.blocks-gallery-caption{color:#555;font-size:13px;text-align:center;}.is-dark-theme .blocks-gallery-caption{color:rgba(255,255,255,.65);}:root :where(.wp-block-image figcaption){color:#555;font-size:13px;text-align:center;}.is-dark-theme :root :where(.wp-block-image figcaption){color:rgba(255,255,255,.65);}.wp-block-image{margin:0 0 1em;}.wp-block-pullquote{border-bottom:4px solid;border-top:4px solid;color:currentColor;margin-bottom:1.75em;}.wp-block-pullquote cite,.wp-block-pullquote footer,.wp-block-pullquote__citation{color:currentColor;font-size:.8125em;font-style:normal;text-transform:uppercase;}.wp-block-quote{border-left:.25em solid;margin:0 0 1.75em;padding-left:1em;}.wp-block-quote cite,.wp-block-quote footer{color:currentColor;font-size:.8125em;font-style:normal;position:relative;}.wp-block-quote:where(.has-text-align-right){border-left:none;border-right:.25em solid;padding-left:0;padding-right:1em;}.wp-block-quote:where(.has-text-align-center){border:none;padding-left:0;}.wp-block-quote.is-large,.wp-block-quote.is-style-large,.wp-block-quote:where(.is-style-plain){border:none;}.wp-block-search .wp-block-search__label{font-weight:700;}.wp-block-search__button{border:1px solid #ccc;padding:.375em .625em;}:where(.wp-block-group.has-background){padding:1.25em 2.375em;}.wp-block-separator.has-css-opacity{opacity:.4;}.wp-block-separator{border:none;border-bottom:2px solid;margin-left:auto;margin-right:auto;}.wp-block-separator.has-alpha-channel-opacity{opacity:1;}.wp-block-separator:not(.is-style-wide):not(.is-style-dots){width:100px;}.wp-block-separator.has-background:not(.is-style-dots){border-bottom:none;height:1px;}.wp-block-separator.has-background:not(.is-style-wide):not(.is-style-dots){height:2px;}.wp-block-table{margin:0 0 1em;}.wp-block-table td,.wp-block-table th{word-break:normal;}.wp-block-table :where(figcaption){color:#555;font-size:13px;text-align:center;}.is-dark-theme .wp-block-table :where(figcaption){color:rgba(255,255,255,.65);}.wp-block-video :where(figcaption){color:#555;font-size:13px;text-align:center;}.is-dark-theme .wp-block-video :where(figcaption){color:rgba(255,255,255,.65);}.wp-block-video{margin:0 0 1em;}:root :where(.wp-block-template-part.has-background){margin-bottom:0;margin-top:0;padding:1.25em 2.375em;}

Automated EDI files processing - Healthcare

WHAT’S NEW

Introducing Astera 10.5

Astera Reportminer wins again

Astera Data Academy

Start Here

Charting Business Value Through Data Driven Decisions

Data-driven Finance with Astera Data Stack

Blogs

The Automated, No-Code Data Stack

Using File Lookup Transformation in Centerprise Data Integrator

This video shows how to use file lookup transformation in Centerprise Data Integrator.

Authors:

Considering Astera For Your Data Management Needs?

Company

Partners

Customers

Support

Automated EDI files processing - Healthcare

WHAT’S NEW

Introducing Astera 10.5

Astera Reportminer wins again

Start Here

Charting Business Value Through Data Driven Decisions

Data-driven Finance with Astera Data Stack

Upcoming Webinar

Automated Data Pipelines for Your Modern Data Needs

Unify, Automate, and Accelerate Your Data Pipelines

Blogs

The Automated, No-Code Data Stack

Using File Lookup Transformation in Centerprise Data Integrator

This video shows how to use file lookup transformation in Centerprise Data Integrator.

Authors:

You MAY ALSO LIKE

The No-Code Revolution: Empowering Non-Techies to Transform Document Workflows

Using File Lookup Transformation in Centerprise Data Integrator

Open Source vs. Closed Source LLMs: Which is Better for Enterprises?

Considering Astera For Your Data Management Needs?

Company

Partners

Customers

Support