multiply the rows with dates

[Anonymous]

Hi everyone. I'm new with talend open studio . I have some trouble when using it. Is there any way to I can get my expected output from this input?
INPUT
DATE (yyyymmdd) | ip | FINISHED ( 1:finished; 0: not finish)
2017-01-01 | 111 | 1
2017-01-01 | 222 | 1
2017-01-02 | 333 | 1
2017-01-03 | 444 | 1

EXPECTED OUTPUT
DATE (yyyymmdd) | ip | FINISHED ( 1:finished; 0: not finish)
2017-01-01 | 111 | 1
2017-01-01 | 222 | 1
2017-01-01 | 333 | 0
2017-01-01 | 444 | 0
2017-01-02 | 111 | 1
2017-01-02 | 222 | 1
2017-01-02 | 333 | 1
2017-01-02 | 444 | 0
2017-01-03 | 111 | 1
2017-01-03 | 222 | 1
2017-01-03 | 333 | 1
2017-01-03 | 444 | 1

Can someone show me the way to do it?
Your help is very much appreciated.
Regards, 

Thang

[fdenis]

hi,
use your fist file as source (3 times)
one for date tfileInput --> taggregate
one for ip tfileInput
one for done status tfileInput

use tmap to link all 3 input.
main is date lockup (all match match on nothing Full Join) to Ip
lockup to don match on Ip

add condition on the Finiched output to compare date

good luck

[Anonymous]

hey fdenis . How can I fist file when it all store in one excel file so I have already linked excel file through tmap then take 3 cols I need.

Then I linked tmap main to taggregaterow ( I don't see taggregate available in my version so I used taggregaterow instead) but when I linked taggregaterow main to the next tmap(I called it tmap_6) , i couldn't link anything main to the tmap_6. Could you add some images? I'm new so it's hard for me to follow your instruction. 

Looking forward to your responce

Regards, 

Thang

[fdenis]

I'm sorry I cannot add pics.
extract data from your excel store data split dataset by 3 with tmap (using previous message) store data (in temp files tFileDelimitedOutput or thashoutput).
then use This 3 files to link them together.

[Anonymous]

hi fdenis. I still can link all 3 files to tmap . Just can connect 1 by main

[Anonymous]

this is my current etl format. I followed some intruction online to link 3 tfileoutputdelimited but none of them worked

Screenshot from 2018-10-02 09-39-49.png

[fdenis]

first you have to build your 3 delimited files.
tFileExcelInput --> tMap --> tFileDelimited1
--> tFileDelimited2
--> tFileDelimited3

[Anonymous]

After I divined my files into 3 seperate files.I connect it using just like you said then the first time I met this error lol

Screenshot from 2018-10-02 15-22-11.png
Screenshot from 2018-10-02 15-29-49.png

[fdenis · Accepted solution]

so you are new in talend…
have a look to https://www.talendbyexample.com/my-first-talend-job.html
and convert this sample to your job
one excel to one csv first
after, add other output files

[Anonymous]

thanks man.I'll try to figure it after your instruction. Anything else I will post it later at a new topic