Hey,

I am new to this forum and I have an issue which I could not resolve yet in Cognos 11.1 R5.

If I try to move a column from 5th postion to position  , I get the following message:

"MSR-VRF-1124 Table "SBA0.csv" has incompatible column types. Column "Name" type should be in the category of "number"."

I get the same validation issue if I try to create folders and re-organize my columns in these folders.

How did I get there:

1.) I used python (pandas) to slice a big csv file (2 GB) into smaller chunks
2.) I uploaded muliple csv files into Cognos
3.) I created a data module, where I combined all csv files into one piece again (Union in custom tables)
       3.1) There was an issue with one particular column not matching the data type of the rest (I fixed that by casting that particular column)

4.) I created a data group to re-organize my files, everything went well 
5.) I wanted to create folders, so that I can organize my data module and use it properly for reports, dashboard etc.
At this stage I get validation issues as mentioned above.

I checked all columns manually, all data types (text, integer, decimal) are all the same across all csv-files.
The usage and the technical data type are all the same as well.

I attached two pictures, I hope gives you a better overview.
I moved the last column to the top and that caused all the validation issues at VI_2.

Help is really appreciated.
If someone can tell me how to solve this issue in the future that would be great.

Thank you very much in advance.

------------------------------
Mar All
------------------------------

#CognosAnalyticswithWatson

Since it's union, I think you have to keep column at same place to match data type. You may create a view on top of it and reorganize content.

------------------------------
Buddhi Gupta
------------------------------

Original Message:
Sent: Sat April 11, 2020 05:40 PM
From: Mar All
Subject: MSR-VRF-1124

Hey,

I am new to this forum and I have an issue which I could not resolve yet in Cognos 11.1 R5.

If I try to move a column from 5th postion to position  , I get the following message:

"MSR-VRF-1124 Table "SBA0.csv" has incompatible column types. Column "Name" type should be in the category of "number"."

I get the same validation issue if I try to create folders and re-organize my columns in these folders.

How did I get there:

1.) I used python (pandas) to slice a big csv file (2 GB) into smaller chunks
2.) I uploaded muliple csv files into Cognos
3.) I created a data module, where I combined all csv files into one piece again (Union in custom tables)
       3.1) There was an issue with one particular column not matching the data type of the rest (I fixed that by casting that particular column)

4.) I created a data group to re-organize my files, everything went well 
5.) I wanted to create folders, so that I can organize my data module and use it properly for reports, dashboard etc.
At this stage I get validation issues as mentioned above.

I checked all columns manually, all data types (text, integer, decimal) are all the same across all csv-files.
The usage and the technical data type are all the same as well.

I attached two pictures, I hope gives you a better overview.
I moved the last column to the top and that caused all the validation issues at VI_2.

Help is really appreciated.
If someone can tell me how to solve this issue in the future that would be great.

Thank you very much in advance.

------------------------------
Mar All
------------------------------

#CognosAnalyticswithWatson