La commande INLINE

0
41

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

];

LEAVE A REPLY

Please enter your comment!
Please enter your name here