Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Announcement: Certain actions are currently causing a Page Not Found error. This is a known issue and we are working with the platform vendor to investigate and resolve it.
Highlighted
Partner
Partner

How Do I Populate Values For Related Rows

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.

Tags (1)
Labels (1)
1 Solution

Accepted Solutions
anushree1
Valued Contributor

Re: How Do I Populate Values For Related Rows

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.

4 Replies
anushree1
Valued Contributor

Re: How Do I Populate Values For Related Rows

Hi,

Please check the attached

Partner
Partner

Re: How Do I Populate Values For Related Rows

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
Valued Contributor

Re: How Do I Populate Values For Related Rows

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.

Partner
Partner

Re: How Do I Populate Values For Related Rows

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.