10-29-2018 03:07 AM
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?
10-29-2018 06:52 AM
10-30-2018 11:38 AM
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.