Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER 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