How to Map N number of columns from input to output schemas at a time?
I am new to BODI. In my project we are using DAT files, which contains more than 100 columns, as Source. At the Data Flow Level, in Query Transformation we are manually mapping columns from INPUT Schema to OUTPUT Schema one by one.
Is there any way to MAP all the columns at a time from INPUT schema to OUTPUT schema.
Hope I am clear with my question.
Thanks for your support.
Christian Wunderlich replied
I am not sure if I understand your question correctly. If you e.g. want to map all columns from the left hand side to the right hand side you can select the first record on the left hand side, hold the shift key, press the down key, and while holding the shift key, drag all of them over to the right hand side.
If you want to select/unselect individual columns, you can hold the ctrl key and click the columns with the mouse.
I hope that helps.