topic How Do I Populate Values For Related Rows in QlikView

How Do I Populate Values For Related Rows

pnn44794 — Sat, 16 Nov 2024 04:21:37 GMT

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.

Re: How Do I Populate Values For Related Rows

anushree1 — Mon, 25 Feb 2019 06:23:20 GMT

Hi,

Please check the attached

Re: How Do I Populate Values For Related Rows

pnn44794 — Fri, 11 Oct 2019 20:21:00 GMT

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.

Re: How Do I Populate Values For Related Rows

anushree1 — Tue, 26 Feb 2019 08:37:52 GMT

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.

Re: How Do I Populate Values For Related Rows

pnn44794 — Fri, 01 Mar 2019 21:15:54 GMT

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.