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
... View more