Help on the following udf

[former_member452321]

Attached source and target structure Need help on the grouping of two levels on target

source.txt.zip

[Harish · Accepted solution]

Hi Mahesh,

In  your UDF, you are only comparing the adjutant package id, so it will not work if package id is not sorted. So you have below option

1. Sort the inputs with package id before UDF

(Sort package ID and sort by key other inputs)

OR 2. Sort the input inside UDF (which make UDF bit complicated).

regards,

Harish

[former_member452321 · Accepted solution]

Thank you Harish. It worked with sort and sortkey before the udf

[Former Member]

Hi Mahesh,

you can do your grouping using blow mapping logic.

Regards,
Bhavin