How to re-name table and end with -1 ? for example GL_TABLE-1 , i get Syntax error in alias statemen

[paulyeo11]

Hi All

I have a QVW , the table model , GL_TABLE-1 :-

I try to rename the table name to AR_TABLE BY :-

Rename table GL_TABLE-1 to AR_TABLE;

I get error msg below :-

Syntax error in alias statement
Rename table GL_TABLE-1 to AR_TABLE

Paul

[whiteymcaces · Accepted solution]

Either use

Rename table "GL_TABLE-1" to AR_TABLE;

or

Rename table [GL_TABLE-1] to AR_TABLE;

[jmartineze]

Hello, try this:

NOCONCATENATE

For Each i in '$(vFile2020)','$(vFile2121)','$(vFile2122)','$(vFile2123)','$(vFile2124)'

AR_TABLE:
LOAD
'$(i)' as SOURCE_,
[Customer/Vendor Code] AS cust_id_ar,
[Customer/Vendor Name] as company_ar,
[Payment Terms Code],
[Outstanding w/o Tax (LC)] as total_ar,
[AR Invoice Number],
Today() - Date( Date#([AR Invoice Date], 'MM/DD/YY'), 'DD/MM/YYY') as [total number of day due],
SlpName AS SAL_,
[Sub-Industry] AS SEG_T_AR,
Industry_Description as SEG_AR,
ApplyMap('MAP_SEG_PM',[Industry_Description],'OTHERS') as [SEGMENT_C_AR],
Today() - Date( Date#([AR Invoice Date], 'MM/DD/YY'), 'DD/MM/YYY') as [aging_ar]
FROM
$(vRAWPath)$(i)
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

CONCATENATE
NEXT i;

NOCONCATENATE
//Rename table GL_TABLE-1 to AR_TABLE;

[paulyeo11]

Hi Sir

Thank you very much for your help . Your work as well. 

I Am sorry , i just try to use your approach , i notice it cannot work.

As i am not able to ass any command LIKE NOCONCATENATE  before FOR '

The error msg i get is :-

Unknown statement
NOCONCATENATE
For Each i in 'SO_ISDN.CSV'
LOAD

You have any advise ?

Paul

Paul