impossible to combine tmap and tunite whereas files have same format (in the same job)

[citrods]

hello

I have an excel file with many columns

I split this files into sevreal files with tmap.

They all have the same number of columns and the same format.

Then I want to unite this file into one file.

But I cant' do it in one job.

It looks like i have to create one job for tmap and definne with output files.

Then I have to create another job with Tunite and use as input files the output files which were previously generated.

Is it possible to combien tmap and tunite on one job?

[gjeremy1617088143]

Hi , you can't, you'll have to make an on subjob ok and after create 3 tFileInputExcel and unite them with tUnite, or you can create a temporary file first and fill him with the 3 tfileOutputExcel.

[Anonymous]

Hi,

You can achieve this in 1 job .

The output from the tmap you can load it to thashoutput1, thashoutput2, thashoutput3 then from the tfileInputExcel  Trigger onSubjobOK you can have thashinputput1, thashinputput2, thashinputput3 then you can use the tunite component to combine all 3 inputes to 1 out put and you can create a excel output.

Thanks

Kandasamy

[gjeremy1617088143]

thashoutput and input a generaly hide by the designer, you have to go to File -> edit project properties -> designer -> Palette Settings and transfert them from hide to show.

[gjeremy1617088143]

and you can also chain your 3 tHashoutput and you don't have to use tUnite