DATE

[#1]

Hi  Experts,

I don't have any date field in source files.But i want date field  and if i click on 1st date ,i want field sheet data only.

ex:-  date    sheet

       1/10/15  1

       2/10/15  2............... like this.

any one can help me.

[sunny_talwar]

Is sheet a field in your application?

[#3]

Ex: 1th sheet is 1 st date

2nd sheet is 2nd date

[ziadm]

if you are loading from multiple sheets then when you load your sheet from excel files take the sheetname such as sheet1 , sheet2 ..ect and load it into a Field name SheetName

LOAD Field1,

     Field2,

     'sheet1' as MyTableName

FROM

[..\sample.xls]

(biff, embedded labels, table is Sheet1$);

You may have to using Mapping Load to map your dates to the sheet if your data of any day does not follow the chronical order

Mapping

LOAD * INLINE [

    DayField, TableName

    1, sheet1

    2, sheet2

    3, sheet2

    4, sheet3

];