Hello @Vaibhav
Based on the screenshot you provided, it seems like you want to execute certain transformations and sinks based on certain conditions.
To achieve this, you can use the conditional split transformation in your data flow. Here are the steps to add a conditional split transformation:
- Click on the plus sign (+) next to your source transformation to add a new transformation.
- Search for "Conditional Split" and select it.
- Connect the output of your source transformation to the input of the conditional split transformation.
- Click on the conditional split transformation to open its settings.
- In the "Add condition" section, add your condition by selecting the appropriate column and operator and entering the value you want to compare it to.
- In the "Add output" section, add the name of the output and select the transformations and sink you want to execute if the condition is met.
- Repeat steps 5 and 6 for each condition you want to add. Once you have added all your conditions and outputs, connect the outputs of the conditional split transformation to the appropriate sinks. In your case, you can add a condition to check if the value in the "status" column is equal to "approved" and add the transformations and sink you want to execute if the condition is met. Similarly, you can add another condition to check if the value in the "status" column is equal to "rejected" and add the transformations and sink you want to execute if the condition is met.
I hope this helps! Let me know if you have any further questions.
I hope that this response has addressed your query and helped you overcome your challenges. If so, please mark this response as Answered. This will not only acknowledge our efforts, but also assist other community members who may be looking for similar solutions.