Load Inline

[Anonymous]

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

];

[kaushiknsolanki]

Hi,

     I didnt got what you are trying to change. Can you explain in detail.

Regards,

Kaushik Solanki

[#3 · Accepted solution]

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.

[Anonymous]

Thanks for your help. I figured out the problem I was having