Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
LINKEDIN LIVE: Democratizing data to enhance customer-centricity. JULY 29TH REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
pnn44794
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.

Labels (1)
1 Solution

Accepted Solutions
anushree1
Specialist II
Specialist II

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.

View solution in original post

4 Replies
anushree1
Specialist II
Specialist II

Hi,

Please check the attached

pnn44794
Partner
Partner
Author

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
Specialist II
Specialist II

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.

View solution in original post

pnn44794
Partner
Partner
Author

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.