Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi experts,
I need some help. I have a list of customer numbers (e.g. 19156) and a list of transaction numbers (e.g. 400191560169) . The customer number is included in the transaction number. Now I want to find the customer of a transaction.
I could make a join of both tables and than a wildmatch like this
Result:
noconcatenate LOAD *
Resident Source
where WildMatch(transaction, '*' & customer& '*')
The problem is that the tables have 1000000 and 3000000 lines. A join of both tables is not possible (1000000*3000000 lines).
You have any other idea to solve this problem?
May be using MapSubString() with Mapping Table to do this?
Thanks a lot. This should work.
Now I can match the customer name into the transaction number. Now I have something like this: 4004customer48905
I want to have only the customer without the numbers around it. You know how to fix this? The number of digits is variable, so I can´t use the mid-function.
I am not sure I follow...