recno() in inline

[#1]

load

recno(),Customer, Value from inline [
Customer, Value
infy, 20
tcs, 30
infy, 10
tcs, 15
google, 40
google, 400
accenture,353
ibm,3625
accenture,245
];

can any 1 help me y the above script gives error?

I wan recno followed by customer, value.

[marcus_sommer · Accepted solution]

Try:

load

recno() as RecNo, * inline [
Customer, Value
infy, 20
tcs, 30
infy, 10
tcs, 15
google, 40
google, 400
accenture,353
ibm,3625
accenture,245
];

- Marcus

[alexandros17]

this works, simply delete the from clause

load
recno(),Customer, Value
inline [
Customer, Value
infy, 20
tcs, 30
infy, 10
tcs, 15
google, 40
google, 400
accenture,353
ibm,3625
accenture,245
];

[jagan]

Hi,

Remove From clause and use below script

TableName:

load

recno() AS RecordNumber,Customer, Value inline [
Customer, Value
infy, 20
tcs, 30
infy, 10
tcs, 15
google, 40
google, 400
accenture,353
ibm,3625
accenture,245
];

Hope this helps you.

Regards,

Jagan.

[its_anandrjs]

Hi,

You can try also

load
Recno() as RecNO,RowNo() as RowNO
,Customer, Value
inline [
Customer, Value
infy, 20
tcs, 30
infy, 10
tcs, 15
google, 40
google, 400
accenture,353
ibm,3625
accenture,245
];

Regards

Anand

[#6]

thank u all,

I got in this way:

load

Customer, Value ,RowNo() as number inline [
Customer, Value
infy, 20
tcs, 30
infy, 10
tcs, 15
google, 40
google, 400
accenture,353
ibm,3625
accenture,245
];