Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all, i have created a sample layout of what i want to do but am not sure how to execute this in script.
Table 1, Customer
Name | Age | Number |
Anne | 10 | 91121212 |
Ben | 15 | 82342121 |
Cat | 18 | 81321321 |
Table 2, Renamed Customer
Name | Age | Number |
Anne | 10 | 91121212 |
Ben | 15 | 82342121 |
Output:
Name | Age | Number |
Cat | 18 | 81321321 |
NoConcatanate
FinalTable:
Load * Resident Customer;
Add
Load * Resident Renamed_Customer
where not wildMatch(Name, Name);
i have tried this and failed. can anybody help me with this breakdown?