We recommend switching to the latest versions of Edge, Firefox, Chrome or Safari. Using Internet Explorer will result in a loss of website functionality.

Switch doesnt work as expected... Alternative?

Comments

4 comments

  • Avatar
    Infogix Support
    Originally posted by: stonysmith

    The Excel node, by itself, will fail if you specify a hard-coded name for a file that doesn't exist.
    The way around that is to use a DirectoryList node in front of it - that way Excel will simply return zero records

    Then, create a dummy StaticData node that has the columns you require from the Excel, and use the CAT node to force those columns into the stream.

    Attached is a sample.
    Handling Missing Input.brg
    0
    Comment actions Permalink
  • Avatar
    Infogix Support
    Originally posted by: StaticFX

    that part is all fine.. i am using it. the problem is after it.


    CSV file > Filter > Filter > Sort \/>--------------->Switch> output
    | |
    | |
    |---- XREF ---------
    XLS file > -------------Sort--------



    i couldn get an image to work.. lol

    CSV to the switch always wins so it just goes thru..
    I need it to take the XREF path with the XLS file has data/exists

    Can something go in between the CSV sort and switch that will disable if the XLS file loads?
    0
    Comment actions Permalink
  • Avatar
    Infogix Support
    Originally posted by: StaticFX

    Capture.JPG

    wait got it... in the picture case it should only use the APFEED file..

    here it should use the XRef path
    Capture2.JPG
    0
    Comment actions Permalink
  • Avatar
    Infogix Support
    Originally posted by: StaticFX

    Only way it works so far is to use a sleep timer, which is not going to be reliable.
    i mean, i suppose I could use a metacheck.. but then to have to entirely different streams would be crazy. a LOT happens outside of the starting composite


    EDIT:
    well i got it to work by going even higher up. I took Scenario A and put it into a composite
    and Scen B in another...
    then the Directory and file checks feed to 2 metachecks for a certain field.. each feeds into its own composite.
    While its not ideal, it works! lol

    THanks!
    0
    Comment actions Permalink

Please sign in to leave a comment.