Hello Guys!
I need to change the values that are present in the field "Item Codigo" .
For example:
040500603S007C10 to Product 01
010300404S014C01 to Product 02
I had searching the method, i tried use eval, but no success...
There are a couple of ways to do that. One is with eval
.
... | eval "Item Codigo" = case ("Item Codigo"=="040500603S007C10" , "Product 01", "Item Codigo"=="010300404S014C01", "Product 02", 1==1, 'Item Codigo')
The other is with a lookup table. First, create a CSV file (I call it "items.csv") with your item numbers and names. Like this:
ItemCodigo, ItemName
040500603S007C10, Product 01
010300404S014C01, Product 02
Then reference the lookup file in your query.
... | lookup items.csv ItemCodigo as "Item Codigo" | eval "Item Codigo" = ItemName