Transforming a single piece of information into a column

[Anonymous]

Hi everyone, 

I have done some searching, but haven't stumbled upon my question. Hopefully, this isn't a repeat. 

Anyways, I have three lines of information at the top of an automated report. One of the lines is the month for which the report was produced. In this example, it's Dec 2018. How do I get this single piece of information into a newly created date column?

The data is coming from Excel and looks something like this:

(ABC,123... is my terrible attempt at showing Excel's coordinates)

  _______A______________B_______C________D_______

1| blah blah blah     |           |         |                    |

2| blah blah blah     |           |         |                    |

3| Month Dec 2018 |           |         |                    |

4|                            |           |         |                    |

5| Col1                    | Col2  | Col3 | Date            |

6| data                    | data  | data  | 2018-12-01 |

7| data                    | data  | data  | 2018-12-01 |

...

And I would like for the date to be column D or some other position and be repeated down the rows. 

I am grateful for your help!

Thank you!

Cheers!

Michael

[Anonymous]

Hello,

Here is a tMap component in which you can fill in your newly created date column repeatedly.

Let us know if it is what you are looking for.

Here is online component reference about tMap.

https://help.talend.com/reader/qKn3z_Eiw4JM~sZ515DcOw/FHuXUp__rZLP_AIdwzQHDw

Best regards

Sabrina

[David_Beaty]

Hi,

You should probably read the data in twice.....first time to extract the date in cell A3 (header of 2 and row read limit of 1), into a Global Map variable, or something similar, and then the second read to get the row data and populate column D with the previously acquired date value.