Hi All,
I am a beginner with the Data Load Wizard.
I have been facing couple of issues. Seen the similar ones that I am facing on this forum, tried the suggestions but still not able to make it work. Hoping for some more inputs.
1. Transformation Rule:
In one of my uploads, I have to populate a field (in the target table) based on the value of one of the columns in the .csv upload file.
Lets say, I have 10 columns in the table. 9 fields in the file. I created a data transformation rule for the 10th field (SQL query returning single value).
SELECT DISTINCT 10_field_value
FROM TABLE_A
WHERE FIELD_NAME = :9th_field_value
I am not facing any errors but the the values are not being inserted.
2. Custom Process:
I created a custom process to generate a static ID (TEST_ID) for each upload. Using the ADD_ATTRIBUTE (added to wizard collections), I placed the column position as C010 and the attribute value as '10'
Is there anyway, I could make this position dynamic.
Let's say, I have 3 file upload UIs ; with 5,9,4 columns in the files. Can I place the position of TEST_ID as 6,10,5 respectively?
While I don't have issues inserting the data. it's just the display when I get to 'Data Validation' section where the column_name TEST_ID is being displayed but not the Value of it.
I went to the session and noticed that the TEST_ID values is being generated and also inserts are happening without any errors. It's just the display which is bothering.
Versions: 5.1, 12c
Please let me know your inputs.
Thank you all in advance,
Daniel