reading log file, Alias name

[everest226]

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,

tamilarasu‌stalwar1‌

[sunny_talwar]

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

[everest226]

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 · Accepted solution]

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]

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]

Thanks stalwar1‌  it worked out perfectly