I have a requirement where i want to control the enabling and disabling of columns of a talend job via excel sheet using flags as 'Y' or 'N'
Hi Everyone,
I have a requirement where i want to control the enabling and disabling of columns of a talend job via excel sheet using flags as 'Y' or 'N'.
As far as i have researched on this, i have come across tFilterColumns which enables us to edit the schema during output but that's a manual work but i want to have that functionality using Flags column in excel sheet.
I have attached the excel sheet format, So, in the sheet for the columns for which the value is Y i want those column in my output file and for those it is 'N' it should skip those columns itself.
I have attached the sample data and expected output as per the excel sheet.