- Posts: 204
- Thank you received: 1
Column is not mapped to anything
8 years 3 months ago - 8 years 3 months ago #13186
by imchaz
Column is not mapped to anything was created by imchaz
I have an xls spreadsheet that serves as a source. I have a column called "Revenue Data Month". I have it mapped to the WRITER which outputs to another xls Spreadsheet to the same column name "Revenue Data Month". But when it, I get a WRITER error telling me that the Field "Revenue Data Month () is not mapped to anything. But when I look in the Transformer, Validator to the Writer objects, it is mapped. Even previewing the data is showing the data flowing through but in the final WRITER the column is blank.
Last edit: 8 years 3 months ago by imchaz.
Please Log in or Create an account to join the conversation.
8 years 3 months ago #13187
by admin
Mike
ETL Architect
Replied by admin on topic Column is not mapped to anything
Perhaps the field name has spaces at the end/beginning?
Mike
ETL Architect
Please Log in or Create an account to join the conversation.
8 years 3 months ago #13191
by imchaz
Replied by imchaz on topic Column is not mapped to anything
Yes. For some reason the source file does not have any spaces before or after the column name but when I tell it to assign the heading by using the first line it adds a space in the beginning and end
E.g. Source would look like Revenue Data Month but when I tell it to use the the first line it converts it to [ Revenue Data Month ]
I don't know why an added space is inserted when the source does not have the space.
E.g. Source would look like Revenue Data Month but when I tell it to use the the first line it converts it to [ Revenue Data Month ]
I don't know why an added space is inserted when the source does not have the space.
Please Log in or Create an account to join the conversation.