How can i load value from MySQL?

Dear visitor, welcome to Palo Community Forum. If this is your first visit here, please read the Help. It explains in detail how this page works. To use all features of this page, you should consider registering. Please use the registration form, to register here or read more information about the registration process. If you are already registered, please login here.

dr1234

Trainee

Posts: 2

Date of registration: Jan 2nd 2012

Monday, January 2nd 2012, 2:45am

How can i load value from MySQL?

hi all

happy new year!

I have a problem with mysql to palo.

How can i load value from mysql table to palo

ex: mysql 'mypalo' table

pattern_ID doc_ID transaction_id
0 123 1
0 123 2
0 123 3
0 123 4
0 123 5
0 123 6

palo
database: nes
dimensions and global subsets: product
cubes: sale\product

i use 'Extract' and

	MySQL queries
1	SELECT `pattern_ID`, `doc_ID`, `transaction_id`FROM `mypalo` WHERE `transaction_id` = 6

it worked and get

`pattern_ID` `doc_ID` `transaction_id`
0 123 6

how does i load `0` `123` and `6` as `value` to product?

thanks
best regards,

/dr1234