Use case

[abhaysingh]

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

[pradosh_thakur]

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.

[abhaysingh]

Hi pRadosh,

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

[abhaysingh]

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

[pradosh_thakur]

sorry ... my mistake

i didn't realize until you said that

dimension : Field1

try this in expression of the table 

concat(FiledN,',')

[prma7799]

Please check this

Dimension : Filed1

Expression : Concat(FiledN,',')