topic Re: Inserting values in a particular cell in QlikView

Inserting values in a particular cell

adnan_rafiq — Sun, 10 Apr 2016 10:50:36 GMT

Hi friends,

Just wanted to run past a query for the experts and pros. What if I want to put a value in a cell(2,1) and cell(2,2) of an xls or csv file. consider the attached csv. The cell(2,1) and cell(2,2) should be filled with words "Line Item" and "Driver" respectively.

Re: Inserting values in a particular cell

swuehl — Sun, 10 Apr 2016 11:21:18 GMT

Not really sure how you want to proceed from that, but maybe like

LOAD

If(recno()=2,'Line Item',@1) as @1,

if(recno()=2,'Driver',@2) as @2,

@3,

@4,

@5,

@6,

@7,

@8,

@9,

@10

FROM

[Prep.csv]

(txt, codepage is 1252, no labels, delimiter is ',', msq);

Re: Inserting values in a particular cell

adnan_rafiq — Sun, 10 Apr 2016 12:05:43 GMT

Ca this be done with load *?

Re: Inserting values in a particular cell

MarcoWedel — Sun, 10 Apr 2016 20:23:21 GMT

please try to explain with your expected result and the script that your currently use.

thanks

regards

Marco