topic Re: Use case in QlikView

Use case

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

hi guys,

need some help

Input table is

Field1	FieldID
A	1
B	2,3,4

ID Names Master

FieldID	FiledN
1	abc
2	cde
3	vfr
4	bgt

Output Required:

Final Output at UI
A	abc
B	cde,vfr,bgt

Pls suggest how I can achieve it

Regards

Abhay

Re: Use case

pradosh_thakur — Thu, 25 Jan 2018 06:01:37 GMT

script

load Field1,subfield(FieldID,',') as FieldID;

load * inline [

Field1|FieldID

A|1

B|2,3,4

](delimiter is |);

load * inline [

FieldID|FiledN

1|abc

2|cde

3|vfr

4|bgt

](delimiter is |);

use the two required columns in table box.

Re: Use case

abhaysingh — Thu, 25 Jan 2018 06:09:05 GMT

Hi pRadosh,

thanks ..... is it possible to share qvf file for u? actually by mistake I have posted in qlikview community.

Re: Use case

abhaysingh — Thu, 25 Jan 2018 06:14:48 GMT

thanks for your reply, but Pradost output shared is not in required format, could you pls have a look once

Re: Use case

pradosh_thakur — Thu, 25 Jan 2018 06:18:30 GMT

sorry ... my mistake

i didn't realize until you said that

dimension : Field1

try this in expression of the table

concat(FiledN,',')

Re: Use case

prma7799 — Thu, 25 Jan 2018 06:20:30 GMT

Please check this

Dimension : Filed1

Expression : Concat(FiledN,',')