I want to set the default value of the certain column to 1. Should I make the change in the input file by defining the default value as "1".
I tried couple of combinations by making it as 1, or "1", change the field type to String. But nothing works.
How do I set value to 1..? Thanks!
It's a business scenario where they want one of the columns to have default value set to 1.
Is there no way we can do it in Talend..? Thanks!
@KanT,i have tested default value for integer coumn working fine,i believe your file might have spaces,please check.
i am attacing input file and screenshoots.
So this column is a new column and doesn't exist in the input file but I added it in output file.
so, I add the column in output of tmap. and in Tmap try to set it default value to 1. It doesn't work.
can I not set default values in Tmap?
@KanT,you cannot set the default value for the column which not having input in tmap,
since you see harcode the value under Expression of Output section.
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.