Hello, I have the following problem when PQL query tables from my analysis (PyCelonis version: 2.5.0):
After identifying the required space, package , analysis and sheet, I specify the required table:
olap_table_HistoricPOs = published_sheet_OpenPR.components.find("#{Historic_POs}", search_attribute="title")
... and query the table:
olap_query_HistoricPOs = olap_table_HistoricPOs.get_query()
olap_query_HistoricPOs
Some columns are read correctly:
(name='_CASE_KEY', query='"freitextbestellung"."_CASE_KEY"')
and others are not. These get a hash and a brace like this:
(name='#{order_items.SUPPLIER_NR}', query='"order_items". "SUPPLIER_NR"')
This incorrect naming is kept in the subsequently created dataframe:
df_historic_POs = pql.DataFrame.from_pql(olap_query_HistoricPOs, data_model=data_model)
and leads to an empty df in the further notebook:
df_references = {}
df_referencese'historic_POs']= df_historic_POs
df_referencese'historic_POs']
print(df_referencesr'historic_POs'].empty)
True
The PQL table from my analysis is obviously not read correctly.
What could be the reason for this?
I am looking forward to your support!
Best, Conny