Script data loading is order by column name instead of column number

[lou]

Dear Qlik community,

For some reasons, script generation of data loading is now order by column name instead of column number.

Where I can change the parameter to have a script  generation  by column number ?

It's a problem as i have more than 100 fields

Eg 

before :

SELECT 

Id ,

article_description,

Name

From Table1

Now :

select

article_description,

Id,

Name

From table1

Thank you

[pradosh_thakur]

this may be 

select

article_description,

Id,

Name

From table1
order by Id;

[lou]

Sorry if I didn't explain well. 

I load a table from Mysql database using  QlikSense Scrip editor .

The script generates a "SELECT .. " but the order of fields is by field name  instead of the order of column of the table

For instance table1 shows

Client | Name | Adresse | Country 

The result I expect from the script generation is  

SELECT Client, Name, Adresse ,Country from table1

But the script generated is :

SELECT Adresse, Client , Country, Name

[pradosh_thakur]

Ohk. I am not sure how this works may be @rwunderlich  will guide us about this.

[marcus_sommer]

Usually the order of fields within a table isn't important - do you really need it for a certain reason (which one)?

I don't know if the additionally sorting-logic could be disabled or changed within the wizard. If not you could just use the wizard to create a working select-statement  and then overwrite it with a copy from the table-overview from your database or with a quick export of the first row to excel and then adjusting it (transposing and concatenation of the values) - it's should be just a matter of a few seconds.

- Marcus