Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
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
];
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.
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
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
];