Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm trying to change BranchNo's to BranchNames in the Edit Script, but it keeps loading the numbers instead of the name
Any help with something I'm doing wrong or missing??
LOAD * INLINE [
BranchNo, BranchName, F3
0000, Head Office,
0001, Tyger Valley
0002, Klinikem
0003, Palm Grove,
0004, Cape Gate
0007, Oudehof
0008, Sanlamhof
0006, Big Bay
];
Hello Chris,
The first line of your inline load indicates the column names you want to assign. The * in your load statement will be returning all the headings you have listed.
You have 2 options to achieve what I undertsand is your requirement.
1. LOAD * INLINE [ BranchName , BranchNameOld , F3
0000, Head Office,
0001, Tyger Valley
0002, Klinikem
0003, Palm Grove,
0004, Cape Gate
0007, Oudehof
0008, Sanlamhof
0006, Big Bay
];
2.
LOAD BranchNo AS BranchName , BranchName AS BranchNameOld , F3 INLINE [
BranchNo, BranchName, F3
0000, Head Office,
0001, Tyger Valley
0002, Klinikem
0003, Palm Grove,
0004, Cape Gate
0007, Oudehof
0008, Sanlamhof
0006, Big Bay
];
Hope that helps.
Hi,
I didnt got what you are trying to change. Can you explain in detail.
Regards,
Kaushik Solanki
Hello Chris,
The first line of your inline load indicates the column names you want to assign. The * in your load statement will be returning all the headings you have listed.
You have 2 options to achieve what I undertsand is your requirement.
1. LOAD * INLINE [ BranchName , BranchNameOld , F3
0000, Head Office,
0001, Tyger Valley
0002, Klinikem
0003, Palm Grove,
0004, Cape Gate
0007, Oudehof
0008, Sanlamhof
0006, Big Bay
];
2.
LOAD BranchNo AS BranchName , BranchName AS BranchNameOld , F3 INLINE [
BranchNo, BranchName, F3
0000, Head Office,
0001, Tyger Valley
0002, Klinikem
0003, Palm Grove,
0004, Cape Gate
0007, Oudehof
0008, Sanlamhof
0006, Big Bay
];
Hope that helps.
Thanks for your help. I figured out the problem I was having