Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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';
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';
Hi sunny , is generic load works ? if yes how can I write it in a script?
Thank you
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)
Thank you Sunny
one last question
when they wrote Chr(39) what do they mean by it ?
Chr(39) represents single quote (')
Check here: ASCII and Binary Characters (The Characters)