Forum Discussion

AndreaF's avatar
AndreaF
Contributor III
2 years ago

Successfully Load and Transform an Import profile with no data

Hi, I have an import step in a workflow profile, using a connector data source. For the current Scenario/Year there is no data. This is causing an error when I run Load and Transform. I know I can...
Import
Workflow
chul's avatar
chul
Contributor III
2 years ago

You can set the import step to Optional on the Workflow Profile. This will allow you to set the step to Complete even if there is no data.

  • AndreaF's avatar
    AndreaF
    Contributor III
    2 years ago

    By setting the import step to Optional on the workflow profile I can Complete the workflow (using the Complete workflow button), but I still get an error if I run the Load and Transform step. This is an issue because I have a job that goes through all the Base input workflow profiles and run the import. I would like the Load and Transform not to fail so that the job does not fail if there is no data on a workflow profile.

    • kberry's avatar
      kberry
      New Contributor III
      2 years ago

      Hi Andrea - In a similar situation I coded a single dummy record in the data adapter so there would never be no data. The no data errors made it hard to identify the real data load errors, which was a problem. It would be nice to be able to turn this off. I would submit an enhancement request on IdeaStream.