topic Re: Get output table in QlikView

Get output table

Thu, 06 Feb 2014 16:49:02 GMT

Hi i have a table with data

Bike_ID	Bike_Name
1	Royal
1	Enfield
2	Harley
2	Davidson

But i want the output data table like

Bike_ID	Bike_Name
1	Royal Enfield
2	Harley Davidson

How can we get this?

Re: Get output table

brindlogcool — Thu, 06 Feb 2014 16:59:34 GMT

You can get it done by using String aggregation functions

From reference manual..

Load Department, concat(Name,' ') as NameList from abc.csv group by Department

Re: Get output table

Nicole-Smith — Thu, 06 Feb 2014 16:59:42 GMT

Load script like this should do the trick:

Data:

LOAD Bike_ID, Concat(Bike_Name, ' ', RecNo()) as Bike_Name GROUP BY Bike_ID;

LOAD * INLINE [

    Bike_ID, Bike_Name

    1, Royal

    1, Enfield

    2, Harley

    2, Davidson

];

I have also attached a working example.

Re: Get output table

Thu, 06 Feb 2014 17:02:48 GMT

Hi Uday,

You can use Concat Command.

I have done it for you in attached .qvw document.

I hope it will help you.

Best Regards