- 17.9K All Categories
- 3.3K Industry Applications
- 3.3K Intelligent Advisor
- 60 Insurance
- 534.8K On-Premises Infrastructure
- 137.8K Analytics Software
- 38.6K Application Development Software
- 5.4K Cloud Platform
- 109.2K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 70.9K Infrastructure Software
- 105.1K Integration
- 41.5K Security Software
Logic to Lookup a Reference table and Insert Multiple rows ?
Hi ODI folks,
I have Table A, Table B and Table C. Doing a lookup for Columns 1,2,3,4,5( symptoms of a patient, value would be 1 or 0 (yes or no response) from A on B ( which are essentially rows in Table B ). In other words if any patient has multiple symptom match then I need to insert that in to Table C for each symptom. I don't think my SymptomConverter function would return multiple values. How to achieve this ? If you have a different approach please comment as well.
Table A is for Patients, Table B is set of well defined Symptoms (Will not change, static table with only few rows) Table C is the Target containing for internal use.
WHEN ($1 = '1') THEN 'Cough'
WHEN ($2 = '1') THEN 'Fever
WHEN ($3 = '1') THEN 'Headache'
WHEN ($4 = '1') THEN 'Sore Throat'
WHEN ($5 = '1') THEN 'Fatigue'
ELSE NULL END