In first place, I didn't know about DISTINCT (field), thanks for the data!!
In second one. This way of couple loads is called "Proceed Load" (or similar, my english is not good). The upper Load takes the second Load like source of data. Take in mind that the upper will only READ the registers in lower Load.
Left Join
Load DISTINCT (WKNREC)
WKA0CD&'-'&Campagna as KPROMOTIONGRSU; <- your example doesn't have ';', this is important.
Load DISTINCT (WKNREC)
If (Onlynb = 'U', WKCATA, WKNQCD) as Campagna
Resident TableOrders;
This script will never works. Because in lower Load, you didn't read WKA0CD and WKNREC. This fields are used for the upper Load, and if you don't read in lower Load, the data is inexistent for the upper Load. You could use:
Left Join
Load DISTINCT (WKNREC)
WKA0CD&'-'&Campagna as KPROMOTIONGRSU; <- your example doesn't have ';', this is important.
Load DISTINCT (WKNREC)
WKNREC,
WKA0CD,
If (Onlynb = 'U', WKCATA, WKNQCD) as Campagna
Resident TableOrders;
This pair of sentences will Join (with the last readed table), for each distinct WKNREC, KPROMOTIONGRSU with the combination of WKA0CD, WKCATA and WKNQCD data. But you will not Join WKNREC, WKA0CD, WKCATA, WKNQCD and Campagna.
For this example, the best way is to use Phill's sentence. But if you want to know, I like it be useful for you!!
