topic Re: Trasformatio table in QlikView

Trasformatio table

mario-sarkis — Mon, 15 Feb 2016 19:45:27 GMT

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

Re: Trasformatio table

sunny_talwar — Mon, 15 Feb 2016 19:54:26 GMT

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';

Re: Trasformatio table

mario-sarkis — Mon, 15 Feb 2016 20:02:01 GMT

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

Thank you

Re: Trasformatio table

sunny_talwar — Mon, 15 Feb 2016 20:05:07 GMT

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)

Re: Trasformatio table

mario-sarkis — Mon, 15 Feb 2016 20:07:39 GMT

Thank you Sunny

Re: Trasformatio table

mario-sarkis — Mon, 15 Feb 2016 20:09:42 GMT

one last question

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

Re: Trasformatio table

sunny_talwar — Mon, 15 Feb 2016 20:20:09 GMT

Chr(39) represents single quote (')

Re: Trasformatio table

sunny_talwar — Mon, 15 Feb 2016 20:20:39 GMT

Check here: ASCII and Binary Characters (The Characters)