Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

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

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

ar rename.png

1 Solution

Accepted Solutions
whiteymcaces
Partner - Creator
Partner - Creator

Either use

Rename table "GL_TABLE-1" to AR_TABLE;

or

Rename table [GL_TABLE-1] to AR_TABLE;

View solution in original post

3 Replies
whiteymcaces
Partner - Creator
Partner - Creator

Either use

Rename table "GL_TABLE-1" to AR_TABLE;

or

Rename table [GL_TABLE-1] to AR_TABLE;

jmartineze
Partner - Creator
Partner - Creator

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
Master
Master
Author

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