excel column selection

[Anonymous]

hi its urgent pls Help for me....

there is no  Column header in excel...

I need to select column in excel

A B C D E F G H I J K L default column in excel. how to fetch default column wise data in excel

[Anonymous]

Use the following system to refer to the column

LOAD @1,

     @2,

     @3,

     @4,

     @5,

     @6,

     @7,

     @8,

     @9

FROM

    "your excel file"

Here 1,2,3,4.... refer to the column number of your excel sheet.

[Anonymous]

how to merge the column

[#4]

Do you mean you want the data from columns A-L all in one column?

[Anonymous]

LOAD

      @1 & @2 & @3 as Field123,

...

FROM

    "your excel file"

[Anonymous]

my Real requirment is

I Attached Invoice Excel sheet

I need to export another excel format

for example   SNo       InvoiceNo                      Date                                                                          

                    1       5142 / 11-12 -PI               12/5/2011                              

[sebastiandperei]

Yes, it would be better...

I think this invoice cames from a DataBase (SQL, ACCESS, etc..), can you get access to this source?

[bgerchikov · Accepted solution]

Sarath,

Assume you're loading one invoice at the time and Invoice format is the same for all:

Directory

;

Invoice:



LOAD Distinct



    B as [S.No.]



FROM

invoice.xlsx

(ooxml, no labels, table is [sheet1 (2)])

Where Previous(Previous(trim(B)))='S.No.'

;



join load Distinct

 

     J  as InvoiceNo

FROM

invoice.xlsx

(ooxml, no labels, table is [sheet1 (2)])

Where trim(I) = 'No.'

;



join LOAD Distinct



     date( J,'MM/DD/YYYY') as Date



FROM

invoice.xlsx

(ooxml, no labels, table is [sheet1 (2)])

Where trim(I) = 'Date'

;

Thanks!

[Anonymous]

great  Boris Gerchikov

                              can U explain little bit more...and qvw file ..it makes more helpful for me i am a beginner in qlikview. also I need discription column,Rates

[bgerchikov]

Sarath,

you need the data located in 2 columns B and J, correct? To identify S.No. value in B column I used label "S.No." in the same column two rows above:

Where Previous(Previous(trim(B)))='S.No.'

For two other values I used labels located in column "I" at the same row.

In simple words I've selected value in column J based on the value in column I.