how to load different same values in column

[vikasmahajan]

Dear all

I have following script

Load  * INLINE [

          Commentory,id

            AAAA,1

            BBBB,3

            CCCC,5

            DDDD,4

            EEEE,6

            AAAA,20

            BBBB,30

            CCCC,50

            DDDD,40

            EEEE,60

                    ];

I want to display   'AAAA','BBBB','CCCC','DDDD','AAAA','BBBB','CCCC','EEEE'   with combination of id .

Thanks

Vikas

[#2]

Temp:

Load  * INLINE [

          Commentory,id

            AAAA,1

            BBBB,3

            CCCC,5

            DDDD,4

            EEEE,6

            AAAA,20

            BBBB,30

            CCCC,50

            DDDD,40

            EEEE,60

                    ];

Final:

Commentory&''&id as Combo

Resident Temp;

[Digvijay_Singh]

Use Concat(id,';') as expression and Commentory as Dimension in straight table

[marcus_malinow]

Vikas,

you could try using the dual() command.

LOAD dual(Commentary, id) as Commentaryid, *

tc..etc..

Marcus

[pokassov]

Hi!

You can hide column id in chart to achieve your goal

[Anonymous]

Hi Vikas,

Do you want commentary and id columns as one column or all values in commentary and id columns in same row?

[vikasmahajan · Accepted solution]

resolved with declaring variable  =Concat(Commentory , '|')

and use = ValueList( '$(v1)')  to display

Thanks all for your reply

Vikas

[pokassov]

Hi!

Can you attach working example?