0 Replies Latest reply on Dec 22, 2016 10:23 AM by archana.chandra

    Help with DATA LOAD


      I am working on 9.3 version. My requirement is to create join between fixed width file & Excel document. PFA files In CAP File .There is no spacing or special character between columns. The columns can be defined in script as follows @2:8 as [Application Number], @9:10 as County, @11:11 as District, @21:24 as LINE #, @25:31 as [Application Received Date], @32:32 as [Application Status I have to join this file with MAP  how can I write custom sql to join my First table that is CAPS with MAP .