topic Re: Script creating new field in QlikView

Re: Script creating new field

rajeshqvd — Fri, 30 Nov 2018 15:33:32 GMT

ID	Subid	Area	Output
111	1
222	1
333	1
333	2	IND	AUS/PAK/IND
333	3	PAK	AUS/PAK/IND
333	4		AUS/PAK/IND
333	5	AUS	AUS/PAK/IND

Re: Script creating new field

sunny_talwar — Fri, 30 Nov 2018 15:42:37 GMT

Try this

Table:
LOAD * INLINE [
    ID, Subid, Area
    111, 1,  
    222, 1, 
    333, 2, IND
    333, 3, PAK
    333, 4,  
    333, 5, AUS
];

Left Join (Table)
LOAD ID,
	 Concat(DISTINCT Area, '/', -Subid) as Output
Resident Table
Group By ID;

Table:
LOAD * INLINE [
    ID, Subid, Area
    111, 1,  
    222, 1, 
    333, 2, IND
    333, 3, PAK
    333, 4,  
    333, 5, AUS
];

Left Join (Table)
LOAD ID,
	 Concat(Area, '/', -Subid) as Output
Resident Table
Group By ID;

Re: Script creating new field

rajeshqvd — Fri, 30 Nov 2018 15:51:54 GMT

ID	Subid	Area	Output	Required output
111	1
222	1
333	2	IND	AUS//PAK/IND	AUS//PAK/IND
333	3	PAK	AUS//PAK/IND	AUS//PAK/IND
333	4		AUS//PAK/IND	AUS//PAK/IND
333	5	AUS	AUS//PAK/IND	AUS//PAK/IND
444	2		US/PAK/	US/PAK
444	3	PAK	US/PAK/	US/PAK
444	4	US	US/PAK/	US/PAK
555	1		AFG//	AFG
555	2		AFG//	AFG
555	3	AFG	AFG//	AFG

required above output..... thanks for your quick response