How Do I Populate Values For Related Rows

[pnn44794]

Hello:

I have a straight table with related rows, but which only some rows have the needed data.  For example, see attachment, I have Order ID 5930161 that has a Trend Date of 03/26/2019 and a TRENDING START BILLING MONTH of 05-2019 with ORDER_LINE_ID 1002165.  I need ORDER_LINE_ID's 1002164 and 1002166 to also reflect the same Trend Date and TRENDING START BILLING MONTH.  Any ideas on how to accomplish this?  As always, thanks in advance for any and all help.

Some additional notes are that the data is gathered via an Oracle DB and via an Excel spreadsheet, tied together by Order ID.

[anushree1]

Hi,

Please check the attached

[pnn44794]

Hello Anushree:

My fault.  TRENDING START BILLING MONTH does not exist until I create it in the Load script.  I probably should have attached my load script which I have now done.  I'm not sure how to update it with what you've provided, so how should I update the attached load script in order to get this to work?  Any help would be greatly appreciated.  I'm pretty confident the code you provided will work and it's just a matter of getting the load done in the right sequence.

[anushree1 · Accepted solution]

HI,

I am unsure of your requirements and data in hand so all i can suggest is the find the stage at which you need to add the missing fields , then order by the column basis which the values need to be copied from to populate the missing fields and then have the peek function written.

So order by first and then perform a peek function I have used a preceeding load methodology you can use resident load to avoid confusion.

Script which uses resident load is attached for your ease of understanding.

[pnn44794]

Hello Anushree:

My apologies for the delay in responding as I got pulled off of this and onto another fire drill.  Anyway, I've been able to work on this again and your solution (big thanks for the example) does indeed work.  I will work your solution as the correct one.

Thanks you very much for your help.  I appreciate it.