Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
mario-sarkis
Creator II
Creator II

Trasformatio table

Hi All

My Question is I have this sample Data:

PeriodeDate       ID         Product             Count

6/10/2015         1242       AOL                   1

6/11/2015          1302      AOL                   1

6/12/2015          1200     AOL                    1

6/11/2015         1242      Deb                     1

6/12/2015          1302     Deb                     1

Need it to look like this:

  PeriodeDate       ID         AOL                 Deb

6/10/2015          1242         1                     1

6/11/2015          1302         1                     1                

6/12/2015          1200         1                    -

Then finaly :

My condition is to count all ids that has AOL and Debit in this case the count is 2 (IDs>>1242,1302)

Thank you,

hope you can help

1 Solution

Accepted Solutions
sunny_talwar

May be this:

Table:

LOAD PeriodDate,

          ID,

          Product as AOL

FROM Source

Where Product = 'AOL';

Join(Table)

LOAD PeriodDate,

          ID,

          Product as Deb

FROM Source

Where Product = 'Deb';

View solution in original post

7 Replies
sunny_talwar

May be this:

Table:

LOAD PeriodDate,

          ID,

          Product as AOL

FROM Source

Where Product = 'AOL';

Join(Table)

LOAD PeriodDate,

          ID,

          Product as Deb

FROM Source

Where Product = 'Deb';

mario-sarkis
Creator II
Creator II
Author

Hi sunny , is generic load works ? if yes how can I write it in a script?

Thank you

sunny_talwar

It surely can. There are a lot of examples on the community for Generic Load. There is also a document related to Generic Load (The Generic Load)

mario-sarkis
Creator II
Creator II
Author

Thank you Sunny

mario-sarkis
Creator II
Creator II
Author

one last question

when they wrote Chr(39) what do they mean by it ?

sunny_talwar

Chr(39) represents single quote (')