Modify stage

[kollurianu]

Keeping and dropping columns , is there any shorcut instead of typing all the fields that needs to dropped or retained other than typing all field names next to KEEP or Drop KEYword.

Thanks all.

[sud]

Keeping and dropping columns , is there any shorcut instead of typing all the fields that needs to dropped or retained other than typing all field names next to KEEP or Drop KEYword.

Thanks all.

No, however you can save the metadata from any stage and access the Table Definitions and copy column names out of the schema representation within the table Definitions you save.

[Teej]

It's one of several reasons why I keep using Transformer instead of Modify stage. The cost of using Transformers have been vastly reduced over several versions, and is ideal for handling data automatically.

[priyadarshikunal]

It's one of several reasons why I keep using Transformer instead of Modify stage. The cost of using Transformers have been vastly reduced over several versions, and is ideal for handling data automatically.

Teej,

Yes The cost of using Transformers have been vastly reduced over several versions, and is ideal for handling data automatically

but that is still much more than using a modify stage.

Hence it is not always advisable to use transformer every time

Regards,