Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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);
CrossTable (Name, Value)
Load * From YourTableName;
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
];
Hi
use generic load.it may help
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
Thank you Teis this is exactly what i need:)