By the end of this chapter you will be able to:
...
| Code Block |
|---|
select * from SOURCE_ALL_CHANNELS_LIST
order by CustomerRef, Channel
|
(the
...
ordering
...
is
...
needed
...
to
...
support
...
the
...
merge)
When merging directly from database tables –you have to repeat the ordering of data across the query and the pipe; that is, the ordering of data in the database collector query must match the grouping on the pipe from the database collector |
...
- Open the data set you have just generated in
Channel List Reconciliation 2 - Create a filter:
- Where ANY of the following are true
SalesCheckequalsNOInvCheckequalsNO
- Where ANY of the following are true
- Press
- Apply the filter without saving - You will get a list of all non-matched records, that is, all records where the
SalesCheckvalue isNOor theInvCheckvalue isNO