Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I have a QVW doc which is working fine,
I like to know why the table name is durationMap12 ?
Can some one share with me.
:
Paul
Go to Duration tab and change your table name..
// Change name here..
LOAD *,
if(L_issue = '00/00/0000' AND L_move <> '00/00/0000', 'New Product'
,if(S1 > '0' AND S2 > '0' and S3 > '0', 'Fast Moving'
,if(L_issue = '00/00/0000' AND L_move = '00/00/0000', 'Not Order Yet'
,applyMap('durationMap', [No of Months_], '>72 Mth')
))) as Duration1
;
my QVW
I am not getting your question.
What are you expecting over there?
You are getting table name as durationMap12 because you name it.
Regards
Hi Prashant
PM info me unable to open the QVW file i attach,
Can you let me know are you able to open it ?
Paul Yeo
yes.
Hi PM
my QVW file
Pls let me know are you able to open my file ?
Paul
Hi Paul,
I am not able to open you file.
Thanks
Hi Prashant
Do you mean you can open my QVW file which i first send ?
Paul Yeo
Go to Duration tab and change your table name..
// Change name here..
LOAD *,
if(L_issue = '00/00/0000' AND L_move <> '00/00/0000', 'New Product'
,if(S1 > '0' AND S2 > '0' and S3 > '0', 'Fast Moving'
,if(L_issue = '00/00/0000' AND L_move = '00/00/0000', 'Not Order Yet'
,applyMap('durationMap', [No of Months_], '>72 Mth')
))) as Duration1
;
Hi P M
I don't understand what you mean ?
Paul