Skip to main content
Question

Using List of Values (LOV) database table with Excel Flat File

  • August 11, 2023
  • 1 reply
  • 62 views

Forum|alt.badge.img

I have a flow that pulls from an excel doc to an oracle database table. I have created LOVs based on some of the fields. Game plan is to create drop down list in my application.

Question: How can I, within the flow, compare and replace the excel fields Descriptions with the LOV table ID value?

Thanks

1 reply

evieatsafe
Safer
Forum|alt.badge.img+20
  • Safer
  • August 16, 2023

Hi @wizkil​ thanks for your question, I feel like we need more information about your data to give a better answer. Could you provide us with some sample data of your Excel and LOVs?

If you want to copy attributes to your Excel file, you could use a FeatureMerger or FeatureJoiner based on common IDs depending on what your goal is. There are lots of ways to accomplish this task, here are some resources based on the idea above:


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