Lesson Guide: Advanced Data Sorting & Table Action Filtering

In this lesson, you will learn how to slice, dice, and refine your data blocks using the Table Action Node in Noca Flow. Organizing information into rows and columns is highly useful, but you often need to isolate a highly specific subset of those records.

We will walk through how to connect a filtering engine to our opportunity grid and configure multi-conditional logic blocks using OR operators to pull out only the high-priority deals in the Proposal or Negotiation phases.

Step 1: Establish Your Table Source Path

The Table Action node requires an existing structural template to read from before it can run filtering computations.

1. Open your Noca Flow workspace and navigate to the canvas from our previous table creation lesson.

2. Ensure your sequence flows cleanly from Manual Trigger $\rightarrow$ Salesforce Read Object $\rightarrow$ Table Node.

3. Click the + icon immediately following your multi-column Table Node.

4. Search for Table Action in the query box and click Insert to stitch it directly onto your execution line.

Step 2: Target the Node and Select the Filter Command

Now, tell Noca what data set you want to manipulate and what structural function you want to execute.

1. Click on the newly placed Table Action Node to reveal the configuration properties on the right side of the screen.

2. Find the Node source dropdown selection and point it to your preceding Table Node.

3. Open the Action type parameter selection and select Filter.

Step 3: Build Multi-Conditional OR Logic Blocks

Let’s construct the rules that dictate which record rows are allowed to pass through the filter and which ones should be thrown out.

Rule Branch 1: The Proposal Phase

1. Click the Add Condition block to open up your expression builder.

2. Set the target data column variable to evaluate your table’s Stage column.

3. Change your matching evaluation operator to Contains.

4. Type Proposal directly into the string matching value input.

Rule Branch 2: The Negotiation Phase

1. Look directly beneath your first rule statement and click the OR connective button.

2. In this second criteria block, set the column variable target to evaluate the Stage column once more.

3. Keep the operator set to Contains.

4. Type Negotiation into the value input text block.

💡 Logic Check: By choosing OR over AND, Noca will look at each individual row independently and pass it forward if either of those string matches evaluate to true.

Step 4: Publish and Test Your Filtering Matrix

1. Click the Publish and Run utility button in the top management menu to process your workflow in the live debugger engine.

2. Wait for the processing animation to finish illuminating your execution steps.

3. Look below the primary canvas layout and open up the Live Node Data Inspector panel.

4. Click on your Table Action Node inside the logs and page through your compiled arrays.

5. Result: You will verify that all unqualified workflow elements (like Qualification or Closed Lost milestones) have been seamlessly ignored, leaving you with a highly refined, tightly targeted data block containing only proposal and negotiation records!

Key Takeaways

• The Connective Switch: Use OR rules inside your Table Action Node parameters when you want to gather data across a spectrum of different valid text attributes.

• Downstream Delivery: The output array produced by your Table Action filter remains fully tabbed and column-mapped, allowing you to seamlessly map this refined data straight into spreadsheets or custom reports further down the canvas.

Incredible job! You have officially mastered data structuring and dynamic extraction matrices. Keep moving forward through the academy track to see how to format, loop, and send these automated datasets out to your cross-functional platforms!