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

[Yulian]

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;

[F_B]

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