Need Help

[paulwalker]

Hi Community,

I have Excel data source..

i have 3 fields (NAME, LOCATION, PICKING AREA)

Here, every 7 records i want to show filed names..(NAME, LOCATION, PICKING AREA)

Please see excel format... i want to show like that format..

PFA,

[paulwalker]

Anyone faced this type issue????

[sujeetsingh]

You need to follow some thing like this

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='$#,##0.00;($#,##0.00)';

SET TimeFormat='h:mm:ss TT';

SET DateFormat='M/D/YYYY';

SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

Tab:

LOAD * INLINE [

    Name, Location, Pickup

    1, A, AA

    2, D, DD

    3, F, WW

    4, A, EE

    5, A, EE

    6, D, RR

    7, F, RR

    8, T, TR

    9, W, QA

];

Data: NoConcatenate

LOAD

RecNo() as Number

,*

Resident Tab;

DROP table Tab;

MainData:NoConcatenate

LOAD * INLINE [

    Name, Location, Pickup,2

    Name, Location, Pickup,2

    ];

Concatenate(MainData)

LOAD

*

Resident Data where Number<=3;

Concatenate (MainData)

LOAD * INLINE [

    Name, Location, Pickup,3

    Name, Location, Pickup,3

    ];

Concatenate (MainData)

LOAD *

,RecNo() as Phase1

Resident Data where Number>3 and Number<=6;

Concatenate (MainData)

LOAD * INLINE [

    Name, Location, Pickup,4

    Name, Location, Pickup,4

    ];

Concatenate (MainData)

LOAD *

,RecNo() as Phase3

Resident Data where Number>6 and Number<=9;

Drop Table Data;

AllData:

Load

Name, Location, Pickup,Number

Resident MainData ;

DROP Table MainData;

[sunny_talwar]

Is this what you want to achieve? PFA

Best,

S

[sunny_talwar]

Last one had a slight error. Updated version of the application.

Best,

S