[Aaqib Naqati]

Hello,

I have been working on unsupervised learning (clustering models) lately and have been able to gather the data using GraphQL API. This way we integrate with python environment, extract the data for further analysis.

Let me know if you need further details on this. Also it would be good to know what all machine learning problem statements are you working on (if any).

Thanks!

[Aaqib Naqati]

Thank you Warren for the information. It was very helpful indeed.

Thanks!

[Aaqib Naqati]

SM_batch, Stock Reservations..

BTW small modification in my script resulted in resolving the issue. Modified query which worked is given below :

q.Sql.text :=’Select whs.Description from warehouse whs, stock stm,stock_reservations str where + ‘whs.whs_auto_key =stm.whs_auto_key and ‘ + ‘stm.stm_auto_key =’+ stock_reservations[‘stm_auto_key’];

Previous query resulted in the same output in sql developer, what i don’t understand is why is the modified one working where as the old one is not in the forms designer environment…Any idea ?

Best Regards,

Aaqib Naqati

[Aaqib Naqati]

Hello Warren,

Thanks for your response!

Yes i did , it throws error undeclared identifier : STOCK. It is because STOCK table is not present in custom invoice data pipeline.

[Aaqib Naqati]

Hello Jason,

Thanks for your response!

I was able to update the correct PN via SQL script:

Here is my approach to the problem. The wrongly imported parts contained the special character (:) followed by the manufacturer code.

Firstly,I extracted the erroneous parts along with the pnm_auto_key using the simple regex function.

SELECT PN, pnm_auto_key FROM parts_master

WHERE regexp_like (PN, ‘[”:”]’);

Imported the erroneous parts achieved from above query in an external table and ran a query to extract the substring (eradicating : and the text following it)

SELECT REGEXP_SUBSTR(‘A1000040:F9111′,'[^:]+’,1,1) from TABLE_NAME

Then updated the correct PN for the parts in the parts_master based on the new column in the external table ( matched using pnm_auto_key).

Thanks!!

[Aaqib Naqati]

Rolando,

Thanks for your response , but that is a lot of manual work in case we want to clean lot of junk from the parts_master.

Like in my case i have parts in 100’s which need to be cleaned. Doing it manually would take lot of time and with chances of repeating the same mistakes.

Thanks!

[Aaqib Naqati]

Nadim,

Thanks for your help. It worked perfectly…. 🙂

[Aaqib Naqati]

Hello,

Thanks for the help. It worked perfectly.

Appreciate it!

[Aaqib Naqati]

Pietro Race wrote:

Guys I made a quick white paper on Power BI setup to keep your license usage to a minimum

Hi Pietro,

I have been trying to integrate the oracle db with Power BI both using the ODBC as well as the original power BI connector , however i am getting the below error. PFB

Details: “Oracle: ORA-12154: TNS:could not resolve the connect identifier specified

I would like to know that are you guys using the Power BI on the RDP itself or your local machine?

Thanks !