topic Load Inline in QlikView

Load Inline

Anonymous — Tue, 07 Feb 2012 10:47:33 GMT

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

];

Load Inline

kaushiknsolanki — Tue, 07 Feb 2012 11:11:02 GMT

Hi,

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

Regards,

Kaushik Solanki

Load Inline

Tue, 07 Feb 2012 11:19:15 GMT

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

];

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.

Load Inline

Anonymous — Tue, 07 Feb 2012 11:23:13 GMT

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