Exporting Data to a flat file using Variables?

dataservices job design
1

I am taking data from a flat file and loading it into a staging table in HANA. I need to export this data as a flat file in a specific folder. I believe this can be done through the use of variables? I have a script using ‘wait_for_file’ function to pick up flat files for ingestion. Need some pointers on how to export data in a flat file format using variables or any other way.

Thanks.

2

Define your flat file target variables and assign them in a script, place the variables in the target path + file name of the flat file target.

When designer fights you entering your new global variable, by trying to instead populate [$$substitution variables] … either use copy/paste or first enter a space before typing in the global variable, then delete the space when you’re done.

jlynn73 :us: (BOB member since 2009-10-27)