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]

how to get merged column that is description column

[bgerchikov]

Add the following statement (approach is the same):

join LOAD Distinct

    E as Description

FROM
invoice.xlsx
(ooxml, no labels, table is [sheet1 (2)])
Where Previous(Previous(trim(E)))='Description'



;

[Anonymous]

The solution provided will work as long as there is no change in the excel file.

i.e it will fail if there are more than one product or items are there (in that case the data for S.No. 2 and above will not be fetched)

the following will provide a better solution although it is indirect in approach

tab1:

LOAD

    B as [S.No.],

    E as Description,

    recno() as rno

FROM

[invoice.xlsx]

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

;

join load recno() as rec1

FROM

[invoice.xlsx]

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

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

join load recno() as rec2

FROM

[invoice.xlsx]

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

Where trim(B) = 'B.E.D. + SAD';

tab2:

LOAD

    [S.No.] as sno,

    Description as Desc

resident tab1

where rno > rec1

and rno < rec2

;

join load

     J  as InvoiceNo

FROM

[invoice.xlsx]

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

Where trim(I) = 'No.';

join LOAD

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

FROM

[invoice.xlsx]

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

Where trim(I) = 'Date';