Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
gal_polak
Creator
Creator

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

Hi, 

It's not my first time storing table data to CSV, 

but now i get extra unwanted characters in the first column, 

gal_polak_0-1595167999881.png

 

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

 

Labels (1)
  • CSV

0 Replies