No Qualified path for file error when trying to load multiple table from BigQuery

Yulian — Tue, 02 Apr 2024 20:40:24 GMT

Hi,

I am trying to aggregate multiple daily event tables into a single qvd in qlik. I keep getting no qualified path error. Can anyone help please?

LIB CONNECT TO 'Google_BigQuery_(via_Direct_Access_gateway)_analytics4-to-bigquery';

TablesList:
LOAD
table_id,
table_name
FROM
[`analytics_334179191`.INFORMATION_SCHEMA.TABLES]
WHERE
table_type = 'BASE TABLE'
AND table_schema = 'analytics_334179191'
AND table_name LIKE 'events_%'; // Specify the pattern for events tables

LOAD
event_date,
Timestamp#(event_timestamp / 100000, 'YYYY-MM-DD hh:mm:ss.SSS') AS EventDateTime,
event_name,
Money(Num(event_value_in_usd),'$#,##0.00'),
event_bundle_sequence_id,
user_pseudo_id,
user_first_touch_timestamp,
Money(Num(SubField(SubField(SubField(SubField(user_ltv, '{"v":"', 2), '"}', 1), '"v":"', 1), '"v":"', 1)), '$#,##0.00') AS User_ltv,
SubField(SubField(SubField(SubField(SubField(SubField(SubField(SubField(SubField(SubField(SubField(SubField(device, '{"v":"', 3), '"}', 1), '"v":"', 1), '"v":"', 1), '"v":', 1), '"v":"', 1), '"v":', 1), '"v":"', 1), '"v":"', 1), '"v":', 1), '"v":"', 1), '"v":"', 1) AS Operating_System,
SubField(SubField(SubField(SubField(SubField(SubField(SubField(SubField(SubField(SubField(SubField(SubField(device, '{"v":"', 2), '"}', 1), '"v":"', 1), '"v":"', 1), '"v":', 1), '"v":"', 1), '"v":', 1), '"v":"', 1), '"v":"', 1), '"v":', 1), '"v":"', 1), '"v":"', 1) AS Desktop_Mobile,
SubField(SubField(SubField(geo, '"v":"', 2), '"}', 1), '"v":"', 1) AS City,
SubField(SubField(SubField(SubField(SubField(geo, '{"v":"', 5), '"}', 1), '"v":"', 1), '"v":"', 1), '"v":"', 1) AS State,
SubField(SubField(SubField(SubField(SubField(geo, '{"v":"', 3), '"}', 1), '"v":"', 1), '"v":"', 1), '"v":"', 1) AS Country,
SubField(SubField(SubField(SubField(SubField(traffic_source, '{"v":"', 3), '"}', 1), '"v":"', 1), '"v":"', 1), '"v":"', 1) AS Traffic_Channel,
SubField(SubField(SubField(SubField(SubField(traffic_source, '{"v":"', 2), '"}', 1), '"v":"', 1), '"v":"', 1), '"v":"', 1) AS Traffic_Brand,
SubField(SubField(SubField(SubField(SubField(traffic_source, '{"v":"', 4), '"}', 1), '"v":"', 1), '"v":"', 1), '"v":"', 1) AS Traffic_Source,
stream_id,
platform,
items,
is_active_user;

FOR i = 0 TO NoOfRows('TablesList') - 1
LET TableName = Peek('table_name', i, 'TablesList');
[$(TableName)]:
SELECT
*
FROM
`analytics4-to-bigquery`.`analytics_334179191`.$(TableName);
NEXT i;

Re: No Qualified path for file error when trying to load multiple table from BigQuery

F_B — Thu, 22 Aug 2024 11:34:31 GMT

Hi @Yulian ,

the "no qualified path" error in Qlik can occur when you're trying to store data into a QVD file but the path or file name specified in the STORE command isn't correctly formatted or recognized. Else, ensure that the path in the FROM clause is correct.

Hope this helps

topic Re: No Qualified path for file error when trying to load multiple table from BigQuery in Qlik Automate

No Qualified path for file error when trying to load multiple table from BigQuery

Re: No Qualified path for file error when trying to load multiple table from BigQuery