Skip to Content
author's profile photo Former Member
Former Member

About Data appending

Hi all,

I want to have a field appended to a record.

The format of record existing is

A B C D X Y

The format of record to be appended is

A B C - - - Z.

So now I want to make this record as

A B C D X Y Z,

where as I am getting this record as

A B C D X Y

A B C - - - Z

Is it possible to make these two into same record.

Where A B C D are key feilds and x y z are data feilds.

Please help me in this.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Oct 17, 2005 at 10:28 AM

    Hi,

    as your key field of the two records are different, you cannot get them into one record, except you define a 'dummy' key for record 2.

    At which stage do you want to summarize the records? If you are posting them to a ODS, just make sure you can provide the keyfields, set the missing data fields to no update and do a update to the rest.

    Siggi

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Siggi,

      In fact I am going to update this for an ODS. But the feild which needs to be updated doesnt impact the other keyfeilds already present. So at any cost I want to update this to the ODS. So can u guide me how to go ahead with creating a dummy key feild?

      This key feild is a time characteristic.

      Thanks,

      Naveen.A

  • author's profile photo Former Member
    Former Member
    Posted on Oct 17, 2005 at 12:36 PM

    Hi Naveen,

    well, I don't know how you records look like, but here just one tip.

    You get record 1.

    A/B/C/D/X/Y

    Val-A1/Val-B1/Val-C1/Date-D1/Val-X1/Val-Y1

    Then you get record 2

    A/B/C/D/Z

    Val-A1/Val-B1/Val-C1//Val-Z2

    In your update rules to the ods for record one, you update all fields except Z. Everything is fine until now. Now you get record 2. Therefore you need to get Date-D1 in a routine, you don't update X and Y but you update Z. If you are able to get Date-D1 you will see the following in your ODS:

    A/B/C/D/X/Y/Z

    Val-A1/Val-B1/Val-C1/Date-D1/Val-X1/Val-Y1/Val-Z2

    I hope this helps you a bit to solve your issue.

    regards

    Siggi

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Naveen,

      To get the missing characteristics you can write a routine which will have a select statement:

      select single charD from /BIC/AODSNAME00 into RESULT where charA = charA_val and charB = charB_val and charC = charC_val.

      Here you will have to give your characteristics names and values and ODS table name.

      If you still have problem then give me the name of the ODS and characteristics I will send you the select statement.

      Regards,

      RB

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.