[gregbowers]

Hello powerpeanuts,

In q, the select statement operates in a manner that doesn’t allow for the assignment of temporary variables within the select statement itself. Therefore, the behavior you’re describing, where you can assign a temporary variable during select and reuse it within the same column, isn’t supported.

The select statement in q typically operates on columns of a table or on the result of an expression, but it doesn’t support intermediate assignment of variables like in some other programming languages.

To achieve the desired result, you may need to break down the calculation into separate steps or use functions to manipulate the data in the way you intend.

Thanks for sharing https://learninghub.kx.com/forums/topic/select-with-assignment/salesforce cpq

Thank you

Stevediaz

learninghub.kx.com

select with assignment - KX Learning Hub

I remember in q, we can assign a temporary variable during select and use it again in the same column, but seems it is not working.

[gregbowers]

To troubleshoot this issue, I recommend trying the following steps:

1. Clear your browser’s cache and cookies, then try accessing the course landing page again to see if the enrollment status updates correctly.

2. Ensure that you’re using a supported browser and that it’s up to date. Sometimes, outdated browsers can cause unexpected behavior on websites.

3. Check if there are any browser extensions or plugins that might be interfering with the enrollment process. Try disabling them temporarily to see if that resolves the issue.

4. If the problem persists, reach out to the support team for the learning hub. They’ll be able to investigate the issue further and provide specific assistance tailored to your account and situation.

[gregbowers]

you’re encountering an issue with running Python scripts in KX Developer due to the embedPy module not being loaded.

To resolve this issue, you need to ensure that embedPy is properly loaded in your KDB environment. You can do this by adding the following line to your q script before attempting to run any Python code:

\l embedPy.q

This line loads the embedPy module, allowing you to evaluate Python code within your q environment.

Once embedPy is loaded, you should be able to run Python scripts in KX Developer without encountering the error you mentioned.

Regarding your question about using Python to call a q database or vice versa, yes, it’s possible to integrate Python and q. You can use embedPy to call Python functions from q or vice versa. This allows you to leverage the strengths of both languages within the same environment.

Thank you

stevediazsalesforce cpq