changing data type after loop file or zip reading

ekhlas

hello, 

after reading the loop zip file and trying to append multiple data set, data types don't match even though the same column name? 

i tried selecting attribute before the append but the problem is data attributes don't appear.

can i find more suggestion ?

David_A

Hi @ekhlas ,

this can happen if the types differ in the files. Typically this happens if you have number columns and then some extra status codes or missing value encodings.

The simplest solution is to use Append (Robust) or the Append (Superset) operator from the Toolbox extension.

Afterwards the Parse Numbers operator can be helpful to make sure number columns are correctly recognized.

Best,
David

ekhlas

thank you, it worked 

Telcontar120

Another option is to import all fields from all files as nominals, and then later after you do the append you can see which fields contain only numerical values and use Parse Numbers at that point.