Categories
Data flow won't run after selecting a new data source using the parameter prompt.
Hi all, I'm working with a dataflow that is meant to be reused over and over to append new datasets to a master dataset. To make the process as easy as possible we want to use the option to "Prompt to select data source" in the add data step. However, the data flow won't run after selecting a new data source using this prompt. I get the following error and am having trouble figuring out why it is going wrong as everything matches between the old and new dataset except for the names of the datasets themselves. Any ideas?
Also I followed these steps.
Answers
-
If you rename the "input file" to the same name as the original file name — does it then work?
0 -
No, I cannot have two datasets with the same same. When trying to rename the new "input file" I get thrown an error and the rename fails.
0 -
@User_0MSAU - The error in log also points to invalid column <column name>, was it verified as well.
0 -
@Sumanth V -Oracle Yes, all the columns are the same between the two data sources and the flow runs perfectly when replacing the datasets manually inside the dataflow. It's only when trying to use the dataflow prompt that it will not run with a new data source.
0 -
@User_0MSAU - Please let us know if you are seeing this behaviour in OAC or OAS, for further validation.
0 -
@Sumanth V -Oracle Using OAC
0 -
@User_0MSAU I am asking — if you rename XLSX on your hard drive and then upload it… does that work? The fact that it works when replacing the file when editing the data flow makes me think there is an issue with renaming the file.
If so — then the two work arounds would be:
1. Edit the data flow and replace it there
2. Rename your file on your hard drive before uploading with the parameter prompt0 -
@User_0MSAU can you try removing the special characters # (i.e. invoice #) from the column name and see if that helps
0
