Why not try this instead preceding load
Distinct [Customer Code],
applymap('MapTOP_NametoTargets',[Customer Code],null()) as Name
(qvd) where Time_Stamp>=$(vL.Date_Border)
Look at HIC's response here:
There is a bug where WildCard load doesn't behave nicely with the preceding load and creates multiple tables.
Kindly take the resident of your Target table and use Applymap() in that resident table.
Preceding load evaluates your both the tables separately and thus mapping only one table data.
Kindly find attached sample qvw
TEST1.qvw 149.5 K
Thank you, I used the Resident Load Version which solves my issue.
Although I think, Sunnys post is the original problem including the solution:
"Instead a use a For-Next loop should be used:
For each vFile in FileList('C:\path\*.txt')
Load ... From [$(vFile)] ;
Which is identical to
Load ... From [C:\path\*.txt] ;
And within the For-Next loop you can put as many Preceding Loads as you wish..." from HIC.