topic Re: how I will get This? in QlikView

how I will get This?

jonesbrown — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: how I will get This?

trdandamudi — Fri, 05 Oct 2018 11:25:18 GMT

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

Re: how I will get This?

Anonymous — Fri, 05 Oct 2018 12:03:46 GMT

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.

Re: how I will get This?

datagrrl — Fri, 05 Oct 2018 13:25:44 GMT

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.