4 Replies Latest reply: Oct 1, 2013 4:57 AM by Etbin RSS

    External Table Data Issue

    ODI_NewUser

      "FS :   (1=$0.2;  15=$3)

       

       

      Only for games:

       

       

      Desert treasure 2

      Easter surprise

      Halloween Fortune",

       

      Hi i am getting one record like this which is spanning to multiple rows,

       

      But External table discarding

       

      "FS :   (1=$0.2;  15=$3) and Halloween Fortune" in bad file

       

      and putting

       

      Only for games:

       

       

      Desert treasure 2

      Easter surprise

       

      3 records in different rows.

        • 1. Re: External Table Data Issue
          EdStevens

          ODI_NewUser wrote:

           

          "FS :   (1=$0.2;  15=$3)

           

           

          Only for games:

           

           

          Desert treasure 2

          Easter surprise

          Halloween Fortune",

           

          Hi i am getting one record like this which is spanning to multiple rows,

           

          But External table discarding

           

          "FS :   (1=$0.2;  15=$3) and Halloween Fortune" in bad file

           

          and putting

           

          Only for games:

           

           

          Desert treasure 2

          Easter surprise

           

          3 records in different rows.

           

          Huh???

          No one is looking over your shoulder. 

           

          Re: 2. How do I ask a question on the forums?

          • 2. Re: External Table Data Issue
            ODI_NewUser

            Hi,

             

            I am crating an External Table from a csv file , but in one record i am getting values like  as

             

            "FS :   (1=$0.2;  15=$3)

             

             

            Only for games:

             

             

            Desert treasure 2

            Easter surprise

            Halloween Fortune",

             

            But External table discarding

             

            "FS :   (1=$0.2;  15=$3) and Halloween Fortune"records but loading below records in diff rows

             

            Only for games:

             

             

            Desert treasure 2

            Easter surprise

             

            Is their any solution we can put so External table treat this as one value.

            • 3. Re: External Table Data Issue
              BluShadow

              And as Ed said, nobody can look over your shoulder.

               

              We cannot see what is wrong with your external table if we cannot see the code for it?

               

              Just saying "I've got this data and my code isn't working" isn't going to allow anyone to help you.

               

              Post your code for your external table.

              • 4. Re: External Table Data Issue
                Etbin

                Take a look at

                The ORACLE_LOADER Access Driver

                SQL*Loader Field List Reference   How Delimited Data Is Processed

                It seems the only way to get things settled is to preprocess your data file substituting newline characters (\n or \r\n i.e. chr(10) or chr(13)||chr(10)) between double quotes with a character your data file cannot contain before letting the external table examine your data file or use the driver's preprocess option.

                You can substitute the newline characters back when selecting from external table.

                 

                Regards

                 

                Etbin