Skip to main content
Announcements
Marching toward a simplified navigation! READ ON
cancel
Showing results for 
Search instead for 
Did you mean: 
everest226
Creator III
Creator III

reading log file, Alias name

I have apps which ready log file from server , basically it reads all dashboard usage and user,

the following script reads all the apps name , is it possible to change different  document name as alias.

market.qvw as marketing Dashboard

Sales_qvw    as Sales Dashboard.

script which reads document name

Lower(Mid(Document,Index(Document,'\',-1)+1)) as QVWName,

tamilarasustalwar1

1 Solution

Accepted Solutions
sunny_talwar

May be you can use Map SubString here:

MappingTable:

Mapping

LOAD * INLINE [

QVWName, NewQVWName

.qvw, " Dashboard"

];

MapSubString('MappingTable', Lower(Mid(Document,Index(Document,'\',-1)+1))) as QVWName,

View solution in original post

6 Replies
sunny_talwar

You want to create multiple fields? or QVWName should contain marketing Dashboard, Sales Dashboard instead of market.qvw or Sales.qvw?

everest226
Creator III
Creator III
Author

Hi Sunny thanks for reply ,

only one Field is QVWName ,

in that listbox there are all the dashboard name that i want to change

like

market.qvw as marketing Dashboard

Sales_qvw    as Sales Dashboard.

sunny_talwar

May be you can use Map SubString here:

MappingTable:

Mapping

LOAD * INLINE [

QVWName, NewQVWName

.qvw, " Dashboard"

];

MapSubString('MappingTable', Lower(Mid(Document,Index(Document,'\',-1)+1))) as QVWName,

sunny_talwar

Or you can just to

Replace(Lower(Mid(Document,Index(Document,'\',-1)+1)), '.qvw', ' Dashboard') as QVWName

everest226
Creator III
Creator III
Author

here is the attachment,

apps is qvw name,

research- testing      as     research for all group

research-validation  as researcher for validation only

sales.qvw     as Sales

all those are coming from this script

Lower(Mid(Document,Index(Document,'\',-1)+1))) as QVWName,

everest226
Creator III
Creator III
Author

Thanks stalwar1‌  it worked out perfectly