google-cloud-platformgoogle-cloud-data-fusioncdap

Adding new column in target in GCP Data Fusion


How to add a new column in target with static values in GCP Data Fusion (with/without wrangler)?


Solution

  • If what you want to do is add a new column named static with the same constant value for each record, say x, you can do so using the set-column directive in wrangler. The expression would look as follows:

    set-column :static 'x'
    

    This directive should be entered in the terminal you see at the bottom when wrangler is open.