pandemkodi Posted May 30, 2012 Report Share Posted May 30, 2012 [quote name='pandemkodi' timestamp='1338328134' post='1301879750'] mams naa source seq file --->tx--->seq file source lo okatey col and daanlo okatey value NULL so nenu TX lo if isnull(col) then nulltoval(col,current date()) else col ani icha but adi target loki still null istondi mama em cheyyali [/quote] Deeni sangatendi mama Link to comment Share on other sites More sharing options...
Silver_mani Posted May 30, 2012 Report Share Posted May 30, 2012 [quote name='pandemkodi' timestamp='1338358900' post='1301881261'] correctey null ithey ney nulltoval kada marchipoya naa mind dobbesindi repu malli try cheta thanks mama [/quote] no prob baa ...chaala rojulu ayyindi mana thread loki vachi Link to comment Share on other sites More sharing options...
pandemkodi Posted June 4, 2012 Report Share Posted June 4, 2012 pivot stage use chesina peddavallu itu randi konchem Link to comment Share on other sites More sharing options...
pandemkodi Posted June 4, 2012 Report Share Posted June 4, 2012 evaru lera Link to comment Share on other sites More sharing options...
qwerty1204 Posted June 5, 2012 Author Report Share Posted June 5, 2012 [quote name='pandemkodi' timestamp='1338854391' post='1301910185'] evaru lera [/quote] cheppu baa emi kavali andhuloo Link to comment Share on other sites More sharing options...
Silver_mani Posted June 5, 2012 Report Share Posted June 5, 2012 Link to comment Share on other sites More sharing options...
pandemkodi Posted June 5, 2012 Report Share Posted June 5, 2012 [quote name='arey ooo samba' timestamp='1338857634' post='1301910483'] cheppu baa emi kavali andhuloo [/quote] Assalu adi ela work avvudho artham kaavtla Link to comment Share on other sites More sharing options...
Silver_mani Posted June 5, 2012 Report Share Posted June 5, 2012 [quote name='pandemkodi' timestamp='1338859034' post='1301910613'] Assalu adi ela work avvudho artham kaavtla [/quote] input : col1 col2 col3 ----> PIVOT STAGE ----------> col1 col2 (col converted as row ) col 3 (col converted as row ) so Pivot column ni rows ga splitt chestadi bhayya ............. Link to comment Share on other sites More sharing options...
qwerty1204 Posted June 5, 2012 Author Report Share Posted June 5, 2012 [quote name='Silver_mani' timestamp='1338859196' post='1301910627'] input : col1 col2 col3 ----> PIVOT STAGE ----------> col1 col2 (col converted as row ) col 3 (col converted as row ) so Pivot column ni rows ga splitt chestadi bhayya ............. [/quote] and vice versa also..if u use the vertical pivot silver baa..pivot stage ki pivot enterprise stage kii diff enti Link to comment Share on other sites More sharing options...
pandemkodi Posted June 5, 2012 Report Share Posted June 5, 2012 here is my input 100 |Tiger | 1 | I am 100 |Tiger | 2 | en 100 |Tiger | 3 | ETL 100 |Tiger | 4 | developer 100 |Tiger | 5 | working fr 100 |Tiger | 6 | om 100 |Tiger | 7 | home 100 |Tiger | 8 | everyday 100 |Tiger | 9 | from 10 am 100 |Tiger | 10| to 10 pm. i need o/p as 100 tiger 1am an etl dev working from home from 10am to 10pm idi nenu dsx lo choosa but pivot use chesi ela cheyyali ani adugutunna naaku req emi ledu but telusukundamani thanks Link to comment Share on other sites More sharing options...
pandemkodi Posted June 5, 2012 Report Share Posted June 5, 2012 DEV'S COMMON RAY Link to comment Share on other sites More sharing options...
chicago Posted June 5, 2012 Report Share Posted June 5, 2012 chepparu vay..... Link to comment Share on other sites More sharing options...
qwerty1204 Posted June 5, 2012 Author Report Share Posted June 5, 2012 [quote name='pandemkodi' timestamp='1338917196' post='1301913793'] here is my input 100 |Tiger | 1 | I am 100 |Tiger | 2 | en 100 |Tiger | 3 | ETL 100 |Tiger | 4 | developer 100 |Tiger | 5 | working fr 100 |Tiger | 6 | om 100 |Tiger | 7 | home 100 |Tiger | 8 | everyday 100 |Tiger | 9 | from 10 am 100 |Tiger | 10| to 10 pm. i need o/p as 100 tiger 1am an etl dev working from home from 10am to 10pm idi nenu dsx lo choosa but pivot use chesi ela cheyyali ani adugutunna naaku req emi ledu but telusukundamani thanks [/quote] aa 100 column name: ID aa Tiger column name: Name aa 1,2,3 column name: Value aa I am column name: Text anukoo so u have four columns namely ID, Name, Value, Text pivot enterprise stage loo pivot properties loo derivation lo aa pivot cheyalisna cloumns add cheyi..then u will get and output column named Pivot(what ever u gave the name of u r o/p column name) then u will get u r required o/p Link to comment Share on other sites More sharing options...
pandemkodi Posted June 5, 2012 Report Share Posted June 5, 2012 [quote name='arey ooo samba' timestamp='1338920155' post='1301914159'] aa 100 column name: ID aa Tiger column name: Name aa 1,2,3 column name: Value aa I am column name: Text anukoo so u have four columns namely ID, Name, Value, Text pivot enterprise stage loo pivot properties loo derivation lo aa pivot cheyalisna cloumns add cheyi..then u will get and output column named Pivot(what ever u gave the name of u r o/p column name) then u will get u r required o/p [/quote] aa pivot deeni meeda cheyyalo cheppu ikkada example lo tikka tikka oytputs vastunnai mama Link to comment Share on other sites More sharing options...
qwerty1204 Posted June 5, 2012 Author Report Share Posted June 5, 2012 [quote name='pandemkodi' timestamp='1338921599' post='1301914488'] aa pivot deeni meeda cheyyalo cheppu ikkada example lo tikka tikka oytputs vastunnai mama [/quote] aa pivot properties lo derivation medha double click chethe..u will get a window baa andhulee u can add those columns need to be pivoted Link to comment Share on other sites More sharing options...
Recommended Posts