I have a lookup table, mylookup.csv, such as:
Key, Value
3, 30
4, 45
5, 52
I have a CSV source mysource.csv, as:
sourceKey, Otherthings
3.0, 300
4.0, 400
5.0, 500
I do a search like: source=mysource.csv | lookup mylookup.csv Key as sourceKey OUPUT Value
This gives nothing. But if I change my lookup table's Key's format as 3.0, 4.0, etc, it could give results.
My question is if there is a way I can lookup and match number fields by their values, regardless of the the formats, whether there are trailing .0s. My situation is my customer would provide these lookup files with different formats(with or without .0s), I would accommodate all these situations.
... View more