Data360 Analyze

 View Only
  • 1.  Identifying the Input record set from an Excel Node

    Posted 10-20-2021 07:38

    I have one input excel , in that there are total of 84 fields, sometimes the Input fields will be like NAME,AGE,CITY.......EMPID.
    AND SOMETIMES THE FIELDS WILL BE LIKE AUTHOR,AUTHOR_AGE,AUTHOR_CITY.......BOOKID...

    We have different logics based on the fields like if the input will come like NAME,AGE .. we have different logic need to perform .. and When The Input fields will like AUTHOR,AUTHOR_AGE we have to perform different logic.

    After reading the input excel through Excel Node file which is connected to the directory node . how we will make sure that which input fields has come so that we can perform that logic..

    Input_Directory(Node)---->Excel(Node)---> 1000 records --- How to identify which set of input fields has come .



  • 2.  RE: Identifying the Input record set from an Excel Node

    Employee
    Posted 10-21-2021 10:26

    The Meta Check node provides the ability to validate a range of attributes of the input data. In this case you can use the 'Expected Fields' property to validate the fields output by the Excel File node. 

    You can then use a Run Dependency to enable the required chain of logic if the conditions are met. A separate Meta Check node can be used to validate the other expected file format and it can be used to enable the execution of a different logic chain using another Run Dependency.