Versions Compared
Version | Old Version 2 | New Version Current |
---|---|---|
Changes made by | ||
Saved on |
Key
- This line was added.
- This line was removed.
- Formatting was changed.
...
Insert excerpt | ||||||||
---|---|---|---|---|---|---|---|---|
|
Scenario
Data is stored in a database, sometimes in massive volumes
...
. You may only need to process a tiny subset of the data. Instead of processing the entire database table, collect a small subset of the data only, based on a variable value.
Create a
...
database collector to retrieve data from a database. This collector should have a
...
where
...
clause in it
...
. The value of that where
clause
...
(the value being looked up
...
) will be set automatically in PhixFlow.
Solution:
- Create a database collector to load some data into a
...
- table in PhixFlow
- Create an
...
- input multiplier on that
...
- table.
- Reference the
...
- input multiplier value(s) in the collector's SQL query using the {} or {=} notation .
...