Skip to main content
  • EN

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

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:

Reply


Community Stats

30,110
Posts
114,303
Replies
37,745
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.