how I will get This?

[jonesbrown]

Hi All

I am new to Qlikview

Plz Help

This my Sample Data

Source Data:

LOAD * INLINE[

sales_mrtyf_GOPI_09_2017

under_gopi_03_2015

sales_mrtyf_RAMESH_09_2017

under_rames_03_2015

sales_mrtyf_SAIDA_09_2017

under_saida_03_2015

];

I want to Output Like this

Field                                                           Name

sales_mrtyf_GOPI_09_2017               Kakanaboyina Gopi

under_gopi_03_2015                         kakanaboyina Gopi

sales_mrtyf_RAMESH_09_2017         Maddi Ramesh

under_ramesh_03_2015                     Maddi Ramesh

sales_mrtyf_ASDF_09_2017                NA

under_xxxx_03_2015                          NA

sales_mrtyf_SAIDA_09_2017             Shaik John

under_saida_03_2015                          Shaik John

[trdandamudi]

The field "Name" on the output is not on the Source Data ? Take a look and let us know.

[Anonymous]

We cannot see the data , if you load those into a table , its just text.

If you want help with extraction from a field, provide some view of the actual data.

It looks like you would need to do data extraction on String's.  So check the Qlikview help file for String functions such as LEFT, RIGHT, MID and Subfield.

[datagrrl]

I think you are missing something. Maybe a translation table? It looks like maybe you are doing a wildmatch on the "field" to link up to a name.