About Data appending

[Former Member]

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.

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

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

[Former Member]

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

[Former Member]

Hi Naveen,

Before doing anything you need to make sure:

1. Always "ABCD" data loaded before "ABC ".

2. "ABC" also identifies the unique records.

If this is true then while loading second request just read the active data table for the ODS with key A,B & C and get the value of key D and then pass this value along with the other values. That means by first load you will have : A B C D X Y blank

With second load will have : A B C blank Z

When you will read ODS with A B C it will give you D, now pass new records as A B C D Z which will make the final Data as A B C D X Y Z.

Hope this will help but don't forget first two point.

Regards,

RB

[Former Member]

Dear Rohit,

Thank you for your reply.

I dont know how to read the record that already loaded to the ods and collect one character based on matching of other characters, for loading the second record. Can you be a bit eloborate about the procedure to do the same.

Thanks,

Naveen.A

[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