Skip to main content
Solved

How to update look up file?

  • November 11, 2022
  • 3 replies
  • 156 views
K
Data Pioneer
Forum|alt.badge.img+1
  1. I created a lookup file from existing attributes in the table but some values are missing so I need to update the look up file. How to do that?
  2. How to create lkp file outside of web interface and upload to ataccama?

Best answer by Maxim Kim

KarthikaSPillai wrote:
  1. I created a lookup file from existing attributes in the table but some values are missing so I need to update the look up file. How to do that?
  2. How to create lkp file outside of web interface and upload to ataccama?
  1. Lookups created out of attributes in One catalog could be updated using “Update Lookup” button in lookup view (Data Quality → Lookup Items → view any lookup → red button on the top right corner). Note, this way you can’t update lookups uploaded from your filesystem (generated by Ataccama Desktop).
  2. Lookups created by Ataccama Desktop could not be updated as far as I remember (for the versions I have used at least). Instead, we uploaded a new version of lookup as a separate entity deleting previous lookup. Note that in rules, lookups were used by name isInFile(value, “lookup:somelookupname”)
View original
    Did this topic help you find an answer to your question?

    K
    Data Pioneer
    Forum|alt.badge.img+1

    @filip.kracmar @Catherine @Siva_Madhavan  Please help

    alexAguilarMx
    Data Pioneer
    Forum|alt.badge.img+2

    Go to the File explorer tab and expand Tutorials > 03 Build lookup (LKP) file. There are 5 examples of how to build new LKP files. 

     

     

    Maxim Kim
    Ataccamer
    Forum|alt.badge.img+3
    • Maxim KimAtaccamer
    • Ataccamer
    • November 22, 2022
    KarthikaSPillai wrote:
    1. I created a lookup file from existing attributes in the table but some values are missing so I need to update the look up file. How to do that?
    2. How to create lkp file outside of web interface and upload to ataccama?
    1. Lookups created out of attributes in One catalog could be updated using “Update Lookup” button in lookup view (Data Quality → Lookup Items → view any lookup → red button on the top right corner). Note, this way you can’t update lookups uploaded from your filesystem (generated by Ataccama Desktop).
    2. Lookups created by Ataccama Desktop could not be updated as far as I remember (for the versions I have used at least). Instead, we uploaded a new version of lookup as a separate entity deleting previous lookup. Note that in rules, lookups were used by name isInFile(value, “lookup:somelookupname”)

    Reply


    Most Liked this week

    Community Terms of Use & ConditionsCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie settings