Missing Junctures

YGUTTIKONDA

Elkbir,

From what i read and understood, the easiest way is to implement this in your Data Model (SQL Query) it is tough to interpret what la.location_gid without looking at your query .. it would be easier if you could just simplify your question.

One other way to approach this is to have separate queries in your data model like Master / Detail or Parent / Child.

0--YG

Antoine KAIBER

FYI, I added the line_sequence field in my Data_Set Ship_Stop and did a juncture between my Data sets Ship_Stop and Stop_Address on the filed '"line_sequence" and I solved the problem of having two "stop_address" blocks in a "Ship_Stop" block. So that's one less problem.

But I still have the biggest problem which is that my Data set "ship_stop" is doubled when I have several line_sequence in the address of the location_gid.

I need to merge these blocks by having only one which would contain

STP_ADD_LINE1 and STP_ADD_LINE2 which woukld correspond to the line of the address but I don't know how to do that. Juncture in the Ship_stop Data set ? Add a clause in the ship_stop DS saying something like  :

,(SELECT address_line from location_address where line_sequence = 1 and location_gid = 'la.location_gid') STP_ADD_LINE1

,(SELECT address_line from location_address where line_sequence = 2 and location_gid = 'la.location_gid') STP_ADD_LINE2 ?

Antoine