Hi,
I am using tmap to get my consolidated output excel, I need to get default values in my output excel sheet columns. How can I set the default values for each fields of my tmap output?
Is there any ways to split and paste the output values in three different rows of an output excel?
Please let me know your pointers and updates.
Thanks and Regards,
Mani.
Hi Volker,
Thanks for the reply,
Please refer the below details,
Column1 Column2 Column3 NewColumn Line
Row 1 value1 value2 value3 default 1
Row 1 value1 value2 value3 tax 1
Row 1 value1 value2 value3 analysis 1
Row 2 value1 value2 value3 default 2
Row 2 value1 value2 value3 tax 2
Row 2 value1 value2 value3 analysis 2
I need to generate the Line values based on the input row readed. (Ex: row 1 the Line value is 1)
How can I get the values based on input rows and the total count of input rows in my tmap.
Please let me know your pointers and updates.
Thanks and Regards,
Mani.
Hi,
if you use tNormalize and set your Numeric.Sequence in front of it, you will get the output as written.
I think the best will be to post an example input and an example output with more real data. Than I could try to write an example job.
Bye
Volker
