Trasformatio table

[mario-sarkis]

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

[sunny_talwar · Accepted solution]

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]

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]

Thank you Sunny

[mario-sarkis]

one last question

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

[sunny_talwar]

Chr(39) represents single quote (')

[sunny_talwar]

Check here: ASCII and Binary Characters (The Characters)