Migration of Excel VBA to Qlikview Solution.

[jagdishbr]

I'm trying to Migrate Excel VBA automation to Qlikview solution and here is the challenge. Is possible to attain the Output Required.

If yes, can you please help with steps to follow.

[Anil_Babu_Samineni]

You can try like below with in Qlikview

Sample:

Load * Inline [

ID12, Subject, Act, Attendee, Com

100|1, Leverage, Expert, Andrew, Ranbaxy

100|1, Leverage, Expert, Milton, Ranbaxy

];

Right Join

LOAD  ID12, Subject, Act, Concat(Attendee, ' | ') as Attendee, Com Resident Sample Group By ID12, Subject, Act, Com ;    

OR

Sample:

Load * Inline [

ID12, Subject, Act, Attendee, Com

100|1, Leverage, Expert, Andrew, Ranbaxy

100|1, Leverage, Expert, Milton, Ranbaxy

];

Final:

NoConcatenate

LOAD  ID12, Subject, Act, Concat(Attendee, ' | ') as Attendee, Com Resident Sample Group By ID12, Subject, Act, Com ;

Drop Table Sample;