Hi,
I have a .csv file containing country codes that looks like:
![](https://uploads-us-west-2.insided.com/ataccama-en/attachment/58a300e7-fe42-40de-bb65-220816ed36de.png)
I want to use this file as a lookup. In ONE Web it is possible to use a .lkp file as a lookup (why not just import an excel file there is beyond me). In order to do this I understoond I had to create a lookup builder:
![](https://uploads-us-west-2.insided.com/ataccama-en/attachment/3e7b45bd-9849-4d5d-b539-28027e05be72.png)
In the Text File Reader I selected the documented with the encoding (I hope this is the right one?). As for the columns I created nm_lnd and kd_lnd (both string).
![](https://uploads-us-west-2.insided.com/ataccama-en/attachment/f5bb8a68-64cb-4b33-bc49-2b041efc59ab.png)
![](https://uploads-us-west-2.insided.com/ataccama-en/attachment/b562a786-7967-4d8a-843d-d89c2bf119da.png)
As for the Lookup Builder:
![](https://uploads-us-west-2.insided.com/ataccama-en/attachment/16a389d4-3cd4-4591-b31a-75564e56da6a.png)
When I run it a .lkp is created but also a rejected.txt with everything that is inside the .csv meaning I'm not able to create the desired .lkp file. What can I do to resolve this? Is there also documentation on how to create lookup using .csv somewhere? I can't find it.