Hi,
It's not my first time storing table data to CSV,
but now i get extra unwanted characters in the first column,
can you please help me understand why?
that's my script:
Tenants:
Load 0 as "tenant_id"
AutoGenerate (0);
Concatenate(Tenants)
LOAD
"tenant_id",
"tenant_name",
"tenant_aws_region",
"db_schema"
;
SQL SELECT "tenant_id",
"tenant_name",
"tenant_aws_region",
"db_schema"
FROM datacentric.ods."v_tenants"
$(TenantsWhere)
Order by 1 ASC
;
Store Tenants into [lib://QVDDATA (win-ikhbn84dk0h_qlikview)/$(QVDFolder)\KPIs\Tenants_list.csv](txt);