Best way to derive values in cross reference file

[Sowmya_Rayavara]

Hi,

I have a requirement where I need to derive a value from cross reference file.(* means any value)

Ex: Cross reference file data
A B C D
1 * 12 2222
2 a 22 1111
3 b * 2323
4 * 13 1315
4 c * 1332

Example Input file- Need to derive the D value from the cross reference file based on input values(A,B,C) combinations.
A B C
1 z 12
1 b 13
2 g 22
3 b 13
4 c 19

I’m using joins to derive the value from cross reference file. Is there any better option to do that?

[Sowmya_Rayavara]

@tstack, @del, @dmiller Can you help me in answering this?

[tstack]

Sowmya_Rayavarapu:

I’m using joins to derive the value from cross reference file. Is there any better option to do that?

I would’ve used a Join snap as well. Are you finding it not very ergonomic? If you post the relevant part of your pipeline, we can take a look and make a recommendation.