Sources Tutorials

Irfan Ahmed2019-09-24T07:57:11+00:00

This help video describes the excel source and how to use it as a data set source in Centerprise.

div.wpgdprc .wpgdprc-switch .wpgdprc-switch-inner:before{content:"Yes";}div.wpgdprc .wpgdprc-switch .wpgdprc-switch-inner:after{content:"No";}@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%;}}.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://nitrocdn.com/GuYcnotRkcKfJXshTEEKnCZTOtUwxDnm/assets/static/optimized/rev-369e576/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://nitrocdn.com/GuYcnotRkcKfJXshTEEKnCZTOtUwxDnm/assets/static/optimized/rev-369e576/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://nitrocdn.com/GuYcnotRkcKfJXshTEEKnCZTOtUwxDnm/assets/static/optimized/rev-369e576/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;}}.page-id-345 .applynow-form-container .field-container .field.file-upload>label{position:static;}@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%;}.parent-pageid-12 .dl-header{z-index:999999;}@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;}.dl-header .dl-main-menu.main_navigation > .dl-menu > li > .sub-menu > li > a{display:none;}.dl-main-menu.main_navigation li#menu-item-17049 ul.sub-menu > li > a{display:inherit;}.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;}

Automate Data Validation in Astera Centerprise

Centerprise Product Brochure

SUPPORT

COMPANY

PARTNERS

CUSTOMERS