When storing table into CSV getting unwanted extra characters in the first column

gal_polak — Sat, 16 Nov 2024 01:51:55 GMT

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);

topic When storing table into CSV getting unwanted extra characters in the first column in App Development

When storing table into CSV getting unwanted extra characters in the first column