Crosstable

[mario-sarkis]

hey all

i need to know how i can transform this form :

ID	Trx	Count
01	Cash Deposits	2509
01	Check Out	737
01	CHI	9
01	CHP	1499
01	CHU	232

into this form

ID	Cash Deposits	Check Out	CHI	CHP	CHU
01	2509	737	9	1499	232

in the script

Thank you,

[teiswamsler]

Hi Mario

Look at this post, maybe it can help you.

crosstable reversed

/Teis

[Clever_Anjos]

This should work

LOAD
  ID,
  sum(if(Trx='Cash Deposits',Count)) as [Cash Deposits],
  sum(if(Trx='Check Out',Count)) as [Check Out],
  sum(if(Trx='CHI',Count)) as [CHI],
  sum(if(Trx='CHP',Count)) as [CHP],
  sum(if(Trx='CHU',Count)) as [CHU]
group by ID;
LOAD ID,
    Trx,
    Count
FROM
[https://community.qlik.com/thread/182932]
(html, codepage is 1252, embedded labels, table is @1);

[MK_QSL]

CrossTable (Name, Value)

Load * From YourTableName;

[maniram23]

Hi,

Try this one, it is helpful for you.

Generic

load * inline [

ID, Trx, Count

01, Cash Deposits, 2509

01, Check Out, 737

01, CHI, 9

01, CHP, 1499

01, CHU, 232

];

[#6]

Hi

   use generic load.it may help

[miguelbraga]

Hey Gergy-sarkis,

Try this:

Table:
Generic LOAD * Inline [
ID, Trx, Count
01, Cash Deposits, 2509
01, Check Out, 737
01, CHI, 9
01, CHP, 1499
01, CHU, 232
];

To get this:

Miguel

[mario-sarkis]

Thank you Teis this is exactly what i need:)