Dynamic multi row reference and assisnment of value (tough one)

[hillard]

Hi,

I have attached the sample input data and explained the ask in that file.

its a bit tricky ask, hopefully you will be able to resolve it. 

Thanks in advance, I would really appreciate your kind support.

[DavidThorpe]

Hi @hillard 

I think I've built a solution to this for you, however I wanted to check some of your logic.

In your example output, you have matched 'OPTION_TYP' twice, with both CE with PE as per the below image:

Is this expected, or do you need to handle CE/PE matches separately?

Take a look at my attached solution and please let me know!

Thanks

David Thorpe

Solutions Consultant

[hillard]

Thank you so much for your support, I need to check both seperately,  it may differ for both ce and pe.

Still, I'll check your solution.