Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Experts,
I have got small problem I hope you guys might help me.
*I dont have field to join. Is there any way I could get what do I need?
Table1:
Key | Customers |
---|---|
1 | Cust1 |
2 | Cust2 |
3 | Cust3 |
Table2:
Barcode | Reg_Customers |
---|---|
B1 | vid1 |
B2 | vid2 |
B3 | vid3 |
What do I need:
AllCusts |
---|
Cust1 |
Cust2 |
Cust3 |
vid1 |
vid2 |
vid3 |
Thanks a ton in advance.
Regards,
Aamir
Hello Aamir,
Use Concatenate.
AllCusts:
Load Customers as AllCusts,
From Table1;
Concatenate (AllCusts)
Load Reg_Customers as AllCusts,
From Table2;
Don't forget to drop the tables you no longer need.
Karl
Hello Aamir,
Use Concatenate.
AllCusts:
Load Customers as AllCusts,
From Table1;
Concatenate (AllCusts)
Load Reg_Customers as AllCusts,
From Table2;
Don't forget to drop the tables you no longer need.
Karl
Thanks for your help Karl
Cheers !