Match Function

[WernerDC]

Hi,

I have this following head scratchier. 

I have fields in my data I want to rename.

For example:

From

C:/QV/QVDEPLOY/LIVE/APP IB 004 - PACKHOUSE ANALYSIS/WAGES - STEENEBRUG/APP IB 004 - FARM ANALYSIS (STEENEBRUG - 90 BESIG MET G).QVW

To

Steenebrug Farm Analysis

This is an App where I created App logs so my users can see how people in the company are using the Apps.

So the issue is that my App (as showed above) is shown so big. 

Attached are 2 snips of what my issues are.

1. In the App the name shows to big

2. Is where I bring in the name

[sunny_talwar · Accepted solution]

May be all you need is a ApplyMap here

[WernerDC]

So should I create a table with all the new names I want?

Can you maybe show me an example?

Upper(Document) as [SESSIONS APP NAME], (This is the column with all the App names.In the script)

C:/QV/QVDEPLOY/LIVE/APP IB 004 - PACKHOUSE ANALYSIS/WAGES - STEENEBRUG/APP IB 004 - FARM ANALYSIS (STEENEBRUG - 90 BESIG MET G).QVW (This is a Typical App name)

Steenebrug - Packhouse (This the name I want to give it.)

Kind regards

[sunny_talwar]

I am happy to share a sample if you are able to share some raw data in Excel format for me to load.

[PrashantSangle · Accepted solution]

Create Inline Table which will contain two field
1: existing app Name
2: New App Name (which you want to show)

Note reduce app Name which you are getting use subfield() to capture only app Name instead of app name with full path
like (SubField(Document),'/',-1) as session_app_name

Regards,