straight table

[srujanaponnuru]

Hi,

i have a source like this in excel.

Manager names
Carry, Jim
Pitt, Brad
Watson, James
Rao, Subba

i need a straight table in qlikview like the below as shown:

Primary	Jim
Secondary	Carry

please suggest how to do.

[HirisH_V7]

Please post some sample data, it will be helpful to look more further. yup! you can exclude 'ID' field from your'e Straight table.

-Hirish

[srujanaponnuru]

Manager names	Application name
Pinto, Noel	abs
Patrick, Marie Jim, carry	dfe
Subba, Rao Noel, Pinto	gff
Brad, Pitt Jim, Carry	gtr
Pinto, Noel	eert
Patrick, Marie Jim, carry	dfesdf
Subba, Rao Noel, Pinto	dfesdfgghj
Brad, Pitt Jim, Carry	v
Pinto, Noel	dfehjilp
Patrick, Marie Jim, carry	dfe677
Subba, Rao Noel, Pinto	dfe345
Brad, Pitt Jim, Carry	dfe234
Pinto, Noel	dfe908
Patrick, Marie Jim, carry	dfel;p
Subba, Rao Noel, Pinto	dfe89;,
Brad, Pitt Jim, Carry	dfeasd
Pinto, Noel	dfeqwe
Patrick, Marie Jim, carry	dfezxc
Subba, Rao Noel, Pinto	dfe23415678
Brad, Pitt Jim, Carry	dfe000

i created a search box in qlikview for application name. so when i click any application in search i need to get the table as shown:

say for example if i search an application "dfe" i need to get like this:

Primary name	Marie Patrick
Secondary name	Jim Carry

please help

[HirisH_V7]

Is it like every app will have their ,Primary and secondary names or what , as i can see from the above data its not like that.

Please provide data in excel sheet,it will be helpful to look for  clear mapping.

[srujanaponnuru]

Manager names	Application name
Pinto, Noel	abs
Patrick, Marie Jim, carry	dfesdf
Subba, Rao Noel, Pinto	gf
Brad, Pitt Jim, Carry	gt
Pinto, Noel	e
Patrick, Marie Jim, carry	dfe123
Subba, Rao Noel, Pinto	dfe456
Brad, Pitt Jim, Carry	v234
Pinto, Noel	dfe567
Patrick, Marie Jim, carry	dfe789
Subba, Rao Noel, Pinto	dfetyuh
Brad, Pitt Jim, Carry	dfenmj
Pinto, Noel	dfecvf
Patrick, Marie Jim, carry	dfedftr
Subba, Rao Noel, Pinto	dfesde
Brad, Pitt Jim, Carry	dfegtyu
Pinto, Noel	dfeuoi
Patrick, Marie Jim, carry	dfeawse
Subba, Rao Noel, Pinto	dfenmjyd
Brad, Pitt Jim, Carry	dfe12wsd

[srujanaponnuru]

sorry cant give in excel. each application has two names.

when i search on application , the table should give me primary name as the first in that cell, and the other as secondary from the same cell.

[HirisH_V7]

Check the very first one, has only one name.

[srujanaponnuru]

which ever application name has one name , secondary name will be null.

[HirisH_V7]

Hi,

Check this,By using the provided data,In front end by selecting 'application name' you can look into 'primary and secondary' managers.

At Script ,By Creating a loop for each 'Application Name' with the [Manager names] column,

Temp:
LOAD [Manager names],
     If(Isnull([Application name]),Peek([Application name]),[Application name]) as Appname,
     [Application name]
FROM
[Manger Names and apps.xlsx]
(ooxml, embedded labels, table is Sheet1);


Data:
NoConcatenate
Load [Manager names],
     Appname
Resident Temp;
Drop Table Temp;


For each Appname in New
Concatenate
New:
load
Concat([Manager names],':') as [New Manager names],
Appname
resident Data
Group by Appname;


Next;


Final_Table:
NoConcatenate
Load Appname,
     [New Manager names]
Resident Data Where [New Manager names]<>Null();


Drop Table Data;

HTH,

PFA,

Hirish