ETL and Data Integration tools - Modern ETL software for everyone

Hi Experts,

I have a source table table like below.

ID,Vegetable
101,Banana
102,Apple
103,Onion

Now I need to generate three flat files with names 101.dat , 102.dat, 103.dat .

I am giving the sample date in one flat file.

Please assist me with above transformation...

Thanks you,
Chary

The trick is to use SourceChanged in calculation


begin
SetVariable('<file_name>',[F001]);
SourceChanged; // creating new file
Result:='test';
end;

Than use this as target file name

<CommonDocumentsDir>\DBSL\DEMO\Buffer\file_{GetVariable('<file_name>')}.txt

Simple

There are couple of examples in default repository

Albert

Slight correction

<CommonDocumentsDir>\DBSL\DEMO\Buffer\{GetVariable('<file_name>')}.dat

Peter