Build batch link

[#1]

Hi, I trying to link different product code in process you can see that I end up with batch and work order, you can see that I usied batch to specific work order then in second row batch number equal work order form previous stage.

I looking to link all 8 rows so when I search 64500 batch I can see all below rows linked to original batch.

Could you help ?

Thanks

[robert_mika]

Could you give some more details?

Attached your data or working file?

[#3]

Please see attachment.

Thanks

[robert_mika]

Wygldalo mi to na zrzut z Excela dlatego poprosilem o ten plik(tez).

W domu uzywam tylko Personal Edition wiec spojrze na to jutro w pracy, chyba ze ktos bedzie szybszy albo dolaczysz plik z Excel.

[#5]

Plik exela.  Dzieki

[robert_mika]

Ok this is your outcome.

What about the data set?

[#7]

This what I can get in sql table.

[#8]

Can anyone help me ?

[robert_mika]

Could post more data or ad another example?

I can not follow your logic.

[sujeetsingh]

Just what you need to do is to create a table structure with the same representation in your Data Model.

Load your entry from the table using resident load.

Use order by Productcode and use previous function as Previous 1 then 2 then 3  what you need.