Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Either use
Rename table "GL_TABLE-1" to AR_TABLE;
or
Rename table [GL_TABLE-1] to AR_TABLE;
Either use
Rename table "GL_TABLE-1" to AR_TABLE;
or
Rename table [GL_TABLE-1] to AR_TABLE;
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;
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